Mysql Concat + Join fields Posted byProsoxi.com Webmaster November 7, 2010 Leave a comment on Mysql Concat + Join fields SELECT CONCAT(last_name,', ',first_name) full_name FROM mytable ORDER BY full_name; [ad code=1]