[SOLVED] MySQL make a row first in result of query

Skyer · 08-12-2011, 05:35 AM

Hello,
I am writing simple CMS which integrates sorting menu based on current category. (So menu for currect category is always first).

It uses MySQL to get menu entries. Entries are placed in ul list, one li for each entry.

Now, I would like to get one entry, based on currect category, in the top of result.

I know there are more ways to approach this using php, but I'd like to keep this logical and systematic - just move the row to the top of query's result.

I'm not very friendly with SQL, so I'd appreciate if you give me some suggestion on how to do it?

Thanks,

Skyer

Guttorm · 08-12-2011, 05:57 AM

Hi

You can do this with some extra "order by" clause. For example, you have a table with two columns, id and name. You want it sorted by name, but the row with id=2 should be first:

Code:

create table test (id int not null,name varchar(255));
insert into test (id,name) value (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'a'),(6,'b');
select id,name from test order by (id=2) desc,name;

Skyer · 08-12-2011, 06:31 AM

Thanks,
that's exactly what I was looking for.

Skyer