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 List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to