how to order string column with speacial words?

Question

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 (readgivebookjobdoor) ... i want to sort them like this jobreaddoorbook.give how can i do this in select query??? i mean not alphabetically

Hemant Srivastava · Answer

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: readgivebookjobdoor 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: jobreaddoorbook.give

Hemant Srivastava · Answer

It's not clear to me in which order you want to arrange your column? Give more details.

Suthish Nair · Answer

Hope above solution helped to resolve your thread. If yes Accept the thread as Answer.

honar abubakr · Answer

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 (redwhitebluegreenblack) i want to order them like this (whiteblackredgreenblue)? know it's clear or not?