mysql help

[karma_machine]

i was wondering if there was a query that i could put in to sort thing first by name then by number.

 

Example

George 21

Jim 18

Bob 21

Bill 16

George 12

 

and have this result

 

Bill 16

Bob 21

George 12

George 21

Jim 18

[PHPcadet]

With MySQL you can specify more than one column in the ORDER BY clause in your SELECT statement as in:

SELECT * FROM mytable ORDER BY name, number

You can even sort each column differently as in

SELECT * FROM mytable ORDER BY name ASC, number DESC

would give you :

Bill 16

Bob 21

George 21

George 12

Jim 18