How is this done in MYSQL. I can't figure it out. In oracle it is this:
Select fname || lname as name from users
Any help would be greatly appreciated!
concatinate two columns in query
Moderator: General Moderators
concatinate two columns in query
Last edited by fitchic77 on Sat Oct 16, 2010 11:26 am, edited 1 time in total.
Have a look for CONCAT() on this page: http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html