Mark Leith wrote:
From: Michael Stassen [mailto:[EMAIL PROTECTED]
snip
Something like
ORDER BY IF(col IS NULL, 1, 0), col
Michael
Or simply:
ORDER BY col IS NULL, col
Which will probably be *slightly* faster..
Good point.
Михаил Монашёв wrote:
Hello
MS Something like
MS
Scott Hamm wrote:
How do I use ORDER BY in a way that it list null last after Z instead of
before A?
I.e. instead of:
Null, A, B, C
result would be:
X, Y, Z, null
How can I get around to that?
Something like
ORDER BY IF(col IS NULL, 1, 0), col
Michael
--
MySQL General Mailing
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: 13 July 2005 13:38
To: Scott Hamm
Cc: 'Mysql '
Subject: Re: Null alphabetic order
Scott Hamm wrote:
How do I use ORDER BY in a way that it list null last after
Z instead
of before A?
I.e