ansaurus

Question

Answer 1

+1 A:

ORDER BY FIELD(type, 'featured', 'premium', 'basic')

You could rearrange 'featured', 'premium', 'basic' upto your needs, and may also put DESC there too

For example

ORDER BY FIELD(type, 'featured', 'premium', 'basic') DESC

or to arrange the rest as normal sorting order.

ORDER BY FIELD(type, 'featured', 'premium', 'basic') DESC, type;

S.Mark 2010-01-26 05:50:53

I can only use this function http://docs.kohanaphp.com/libraries/database/builder#orderbyso, other than DESC and ASC, I have no other option

Ygam 2010-01-26 05:56:17

Imm, so could you specify "with Kohana" in your question title then? and also tag with `kohana`

S.Mark 2010-01-26 05:58:40

I guess, you will end up by calling `->query` directly instead of `->orderby` method like `$this->db->query("SELECT * FROM table ORDER BY FIELD(type, 'featured', 'premium', 'basic') DESC, type;");`

S.Mark 2010-01-26 06:10:46

Nice. Is there a FIELD equivalent in MS SQL Server ?

Liao 2010-01-26 06:40:46

@Ygam, the link you mention, has this code `$db->orderby(NULL, 'RAND()');` .. so, can you not use the FIELD() function that way?

Liao 2010-01-26 07:02:05

the second parameter accepts only 3 strings, ASC, DESC, RAND(), RANDOM(), NULL as values. if anything other than that is specified, it defaults to ASC (I was reading code minutes ago)

Ygam 2010-01-26 07:05:08

Answer 2

A:

I will use group by on hotel type and sort by desc in your case. Try writing the query.

Algorist 2010-01-26 05:51:22

ansaurus

tags:

views:

answers:

sorting with 3 categories

related questions