Skip to main content
Topic: MySQL ORDER BY (Read 172 times) previous topic - next topic

MySQL ORDER BY

Code: [Select]
ORDER BY status ASC; will return 1,2,3,4.

Code: [Select]
ORDER BY status DESC; will return 4,3,2,1.

Code: [Select]
ORDER BY FIELD(status, 3, 2, 4, 1);