ORDER BY, multiple fields

[Anon]

Is it possible to order things in a MYSQL statment twice,

for example

order by people_location, then order by Surname.

Giving me a list of people all living at the same location, in alphabetical order by surname.

Thanks Anand

[[deleted]]

Yes, just put the columns in the ORDER BY statement as required:

ORDER BY this, that, foo, bar