mysql ORDER BY

[Anon]

hey all, quick question.

I have a basic SQL query:

SELECT columns FROM table ORDER BY col1;

This returns the desired result, however now I want to do a second sort on the result, basically "ORDER BY col1, col2".

MySQL supports the syntax of "ORDER BY col1, col2", but this doesn't appear to return what I'm looking for. I have dug throught the docs but can't seem to find anything on the "ORDER BY col1, col2" syntax.

Can anyone help?

Thanks

[micfur]

What does it return and what are you looking for?

[Anon]

It may not make any difference, but I always specify asc or desc order.

e.g.
select field_names from table_name order by field1 asc, field2 asc

Also, remember that sorting character strings and numbers (int, float, etc) is different.

If you were to sort a the integers 2 and 10, it would look like {2, 10}.

If you were to sort the strings "2" and "10", it would look like {10, 2}.

Hope this helps,
DLB