abc
1
2
null
100
6

1
2
6
100
abc
null

select * from test_table where status=1 order by test_column DESC

select * from test_table where status=1 order by if((test_column = '' OR test_column IS NULL),'999999',test_column) DESC