My SQL

Order two columns with different orders – mysql

SELECT * from emp_table ORDER BY category DESC, name ASC;

PHP Code