how to order string column with speacial words?

honar abubakr

hi,
i want to use ORDER BY in my select query but i want to sort the column as like it ... i mean i have some special words in this column i want to sort them:
for example:
the column have this words (read,give,book,job,door) ... i want to sort them like this job,read,door,book.give
how can i do this in select query???
i mean not alphabetically

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair13y ago
Hope above solution helped to resolve your thread. If yes, Accept the thread as Answer.
0
Hemant Srivastava13y ago
Sorry, not very clear to me...anyway it sounds like, you want to sort them in a specific order and that order is defined (or set) by you..
What I am thinking you may add an extra column where you can keep the priority order of the specific elements and then sort the words column by their priorities.For example:

Suppose before sorting you list is: read,give,book,job,door

Not you add extra column 'Priority'

WORD    PRIORITY

read        2
give        5
book       4
job          1
door        3

Then run this SQL query,

SELECT Word_Column
FROM table
ORDER BY Priority_Column

and it will give you: job,read,door,book.give
0
honar abubakr13y ago
ok if you use order by for string column it order the column data alphabetically .... but i want to order the column data as i want ... for example this column in my table have only some special word (red,white,blue,green,black) i want to order them like this (white,black,red,green,blue)?
know it's clear or not?
0
Hemant Srivastava13y ago
It's not clear to me in which order you want to arrange your column? Give more details.
0