Mysql Concat + Join fields

SELECT CONCAT(last_name,', ',first_name) full_name
  FROM mytable ORDER BY full_name;

[ad code=1]