Mark Leith wrote:
From: Michael Stassen [mailto:[EMAIL PROTECTED]
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>O
> -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 l
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 L
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?
--
Power to people, Linux is here.
