ORDER BY none NULL field

[slick101]

hey everyone trying figure out how i can get my order by username but i would like to have users that have a image that is not null first.

SELECT DISTINCT(id), FROM members WHERE active = 1 ORDER BY COALESCE(image,username),username LIMIT 0, 20

but I keep getting the ones that are NULL first?

any help thank you

[bradgrafelman]

Try this instead:

ORDER BY image IS NULL,username

You could also do "ORDER BY COALESCE(image) DESC" to get the same result. Not sure which one is faster.. my guess would be the first version.