Merge issue

  • Thread starter Thread starter Anonymous
  • Start date Start date
A

Anonymous

Guest
you can use concat:
Code:
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
 
Back
Top