mysql order by using code example
Example 1: mysql order
SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC
Example 2: mysql order by list
ORDER BY FIELD(id, 3, 11, 7, 1)
SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC
ORDER BY FIELD(id, 3, 11, 7, 1)