I have this column in mysql:
A
F
D
[ empty ]
A
C
If I do an order by on that column, this is what I get:
[ empty ]
A
A
C
D
F
What I would like is this:
A
A
C
D
F
[ empty ]
Is there any way to achieve this in a single MySQL query? Using DESC
in this case doesn't work, because while it puts the empty row in the
last place, it does the rest as well. I could also do 2 queries where
it calls it once in order WHERE !='', and then do another query to
get the empty ones, but that seems a bit cumbersome.
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
