Mysql Concat + Join fields SELECT CONCAT(last_name,’, ‘,first_name) full_name FROM mytable ORDER BY full_name; [ad code=1]