is there a better way
I have a column called priority that's an INT.
When I INSERT, the value in priority defaults to 0.
When I ORDER the column the zeros go to the top of the list.
I want them at the bottom of the list so I simply recode all zeros to 99. That solves my problem, but I'd like to know if there's a better way?
I'm assuming you still want 1, 2 and 3 towards the top of the list so ORDER BY priority DESC would be out of the question. Couldn't you just change the default to 99 instead of 0?
For everything there is a first time. Never thought of it that way, DUH! More proof that I see what I expect to see.