MySQL query question

[LucL]

Say I have a query.

"SELECT * FROM content WHERE description=SOMETHING OR description LIKE %something%"

I want to have the top conditional list all results first and then the second conditional (since description=something will be more relevant). So, the first results should be all those where description=something, however many there may be, and then the second OR conditional.

Is there any way to do this without two seperate queries?

Thanks!
Luc L.

 

[guelphdad]

SELECT 
foo,
bar,
description
FROM content 
WHERE description='SOMETHING '
OR 
description LIKE %something%
order by
(case when description='SOMETHING' then 0 else 1 end)

 

[LucL]

very awesome. that worked perfectly. THANKS!