mysql_string......sorting data with parameter

PHP
1

Hi,

I am sorting data in mysql and I want to put a value in top and the rest after that order by ascending or descending.

e.g.

I’ve 5 categories in my table.

I want to sort it…like.

3
1
2
4
5

Please let me know what mysql string I can use…

Thanks

2

Check out ORDER BY at the manual.

3

ORDER BY CASE WHEN cat <> 3 THEN ‘humpty’ ELSE ‘dumpty’ END, cat

:smiley: