Merge issue

Codes here !

Moderators: macek, egami, gesf

Post Reply
DoppyNL

Post by DoppyNL » Sat Oct 05, 2002 7:32 am

you can use concat:

Code: Select all

SELECT concat(`field1`,`field2`,`field3`) as `workname` FROM `sometable` ORDER BY `field1`;

this will return all records from the table and only one column named "workname" wich is field1 + field2 + field3.

See also Mysql Manual - Function Concat

Greetz Daan

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests