Hi All,

Am trying to display/select 2 column filed values under single coulmn. ie,

If i have table with 3 columns and 4 rows, i would like to select/display col1 and col3 values and display there values as single column values.

Example :

col1 col2 col3
aaa sss ddd
qqq www eee
rrr ttt yyy
xxx fff ggg

now from the above table, i would like to display col1/col3 values as single col4 ie, output should look like

col4
aaa
qqq
rrr
xxx
ddd
eee
yyy
ggg

i tried with UNION and CONCAT but no luck. could anyone please tell me how to do this using mysql query.

Many Thanks,
V

I'm not sure what you mean. Do you want to concatenate the two columns together? Or do you want to *append* col3 to col1?

For concatenation:
SELECT CONCAT(col1,col3) as newCol_ FROM table_name

You may have to cast the data in col1 or col3 to varchar depending upon the datatype they are (your posting is a little short on details).

Fro the second case, you'll have to create a new table (a temporary one should suffice) and dump you col1 and col3 data there sequentially.

Thanks GATTACA. I looking for the second solution which you have mentioned.

Need to append col3 values under col1

I don't know how to do it without creating tmp table.