Sort over two or more columns

[tomschi]

I need to select keywords from two or more columns of a table and print them in one column.
I like to sort these keywords in the output alphabetically, i.e. keywords from column 1 and 2 need to be inserted at the proper place in the one output column.

Can that be accomplished with Mysql and PHP?

Thanks for your help

Tomschi

[Sxooter]

Normally, collapsing two columns into one column involves a union, but I don't think MySQL supports those, so you get to do it yourself.

You can either create a temp table and select the two output streams there and then do an order by on the temp table, or you can grab the data into a single array in PHP and use array_sort on it.

[Drakla]

I just did a quick search for UNION in the MySQL manual and it's included it since version 4 - wahey! Get downloading and upgrading.