Unanswered: need help on custom order by (dunno if this is the correct sub forum)
im using oracle 9 and im using
JDBC connection for my application.
Basically this is what happens, i have this table called symbol, and in this i have a column called name.
My application right now do a search in the name.
For example, when user enters "micro" in the search box, the application will run a sql statement which will look into symbol table with name that contains "micro" in it. Then right now it is ordered alphabetically.
What i want to do is to order it in this way:
- names that start with the word the user search will be the first ones to appear
- and the rest will be sorted alphabetically
for example if user search for microsoft it will return something like
abe micro goods
trend micro AV
something like that.
Stumbled across order by case.. tried that, it doesnt work. Anyone can help me with this?