query problem - Printable Version

query problem - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: query problem (/showthread.php?tid=38621)

query problem - El Forum - 02-13-2011

[eluser]Bigil Michael[/eluser]
is it possible to select distinct values from three columns of same table

Code:
table name   tour_package

columns id  tour_type1          tour_type2       tour_type3

         1   pilgrim tour      leisure tour      Beach Holidays

         2   Hiking Holidays    Hiking Holidays  Adventure Tours

i want the result like this

pilgrim tour

leisure tour 

Beach Holidays

Hiking Holidays

Adventure Tours

i want the result in a single query, is it possible???????

can any one help me??
thanks in advance...