SQLite ordering

[adrian rowlands]

i have a table that i currently use to fill a spinner with in alphabetical order, i was wondering if there was a way where i could set a certain row as always top then order the rest below it in alphabetical order?

"SELECT * FROM " + TABLE_ITEM + " WHERE " + COLUMN_CATEGORY + " = ? " + " ORDER BY " + COLUMN_ITEM_VALUE + " DESC" + " LIMIT 10";

thats the code im currently using

[Tim Holloway]

I think what you actually want to do is pre-select a certain item in your spinner. Yes, you could arrange the data in broken alphabetical order, but it's a lot of work and it's likely to confuse the user. So instead of doing database tricks, I'd recommend that you simply pre-select the spinner to the preferred value.

[adrian rowlands]

Ye I can do that but I have an show all option in the spinner and id like that to always be first so the user doesn't have to go search for this

[Tim Holloway]

Probably the easiest thing to do then, would be to take the List of returned items, remove the preferred element from the list and re-add it to the top. Doing it in SQL is an ugly process and I'm not even sure SQLite's SQL capabilities extend to some of the features required.