ordery by problem in codeigniter

[eluser]Unknown[/eluser]
I had a simple problem in ordery by . Actually i had to order by d, a , b ,c . and if i did
by asceding order d comes at last . but i want the d datas to be come at first.

[eluser]Aken[/eluser]
Maybe this will help.

[eluser]Unknown[/eluser]
Thank you so much . It really works .

[eluser]jmadsen[/eluser]
That is a good solution, but if you are able to, set it up with ENUM datatype and order the values the way you will want them in the query. It is a faster query.

[eluser]Aken[/eluser]
Yeah, an enum column, or a specific sort order column, both of which can be indexed, will be much faster.

[eluser]Abel A.[/eluser]
enum is a better/faster solution.

[eluser]Mirge[/eluser]
[quote author="Aken" date="1343978848"]Maybe this will help.[/quote]

bookmarked, that's handy!