MySQL - ORDER BY

"users" table:

user_id name city age
1 John DoeNew York15
2 Jimmy McNultyLos Angeles44
2 Andrew WilkinsChicago15
2 Bob SeizmoreNew York16

SELECT * FROM users
ORDER BY name;

Result:

user_id name city age
2 Andrew WilkinsChicago15
2 Bob SeizmoreNew York16
2 Jimmy McNultyLos Angeles44
1 John DoeNew York15