Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: open
SELECT * FROM `users` ORDER BY colname ASC
Is there any way to do this?
select * from `users` order by colname>0 desc, colname asc
Should float all the values > 0 to the top. At first it doesn't seem like it would work, but after you think about it, the facepalm comes. :-)