nichemtktg — 2012-11-01T13:37:43-04:00 — #1
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?
cpradio — 2012-11-01T13:43:06-04:00 — #2
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?
nichemtktg — 2012-11-01T13:51:04-04:00 — #3
For everything there is a first time. Never thought of it that way, DUH! More proof that I see what I expect to see.