how to order string column with speacial words?

Sep 13 2013 10:51 AM

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