Sorting multiple fields in MySQL
You can add as many fields to ORDER BY as you want.
That'd be something like:
SELECT * FROM table ORDER BY `date` DESC, `importance` DESC
SELECT * FROM yourtable
ORDER BY `DATE` DESC, `IMPORTANCE` DESC
You can add as many fields to ORDER BY as you want.
That'd be something like:
SELECT * FROM table ORDER BY `date` DESC, `importance` DESC
SELECT * FROM yourtable
ORDER BY `DATE` DESC, `IMPORTANCE` DESC