orderby id null code example
Example 1: mysql order by desc null last
SELECT * FROM user
ORDER BY COALESCE(name, 'zz') DESCExample 2: mysql order by date asc null last
ORDER BY IF(ISNULL(my_field),1,0),my_field ASCSELECT * FROM user
ORDER BY COALESCE(name, 'zz') DESCORDER BY IF(ISNULL(my_field),1,0),my_field ASC