SELECT id, <X> AS name FROM `table`

Basically <X> is a combination of
lastname + ', ' + firstname

example would be

   id | name        |
   2  | Smith, Bob  |
   3  | Jones, Susy |

This is just an example, I don't really want to combine names so simple.

mysql select
Edit
Report