Answers for "sort the table which value is not null, mysql"

SQL
0

mysql order by desc null last

SELECT * FROM user 

ORDER BY COALESCE(name, 'zz') DESC
Posted by: Guest on May-04-2020
0

mysql order by date asc null last

ORDER BY IF(ISNULL(my_field),1,0),my_field ASC
Posted by: Guest on May-04-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language