Order by

[7724]

Hi,

I have a simple tbl like so with 100's of records in it:

id | name | order
----------------
1 | Jon | 0
2 | Jim |1
3 | Fred | 0

Now, I want to include all of these records in a query but I was wondering if there was any way I could order by asc starting from 1 rather than Zero?

Thanks

[Kailash Badu]

SELECT * FROM tbl ORDER BY `order` ASC;

[7724]

Yes, but that wll start the order at 0 though I want it to start at 1???

[r937]

ORDER BY CASE WHEN order=0 THEN 937 END, order

[7724]

Thanks!

[7724]

Out of interest if I then wanted to order by another two columns after this ie:

, published DESC , id DESC

SELECT *
FROM `test_stories`
ORDER BY CASE WHEN order =0
THEN order =1, published DESC , id DESC

[r937]

SELECT *
FROM `test_stories`
ORDER BY CASE WHEN order =0
THEN order =1, published DESC , id DESC

that's invalid syntax

did you try mine?