One problem w/ LIMIT in CASE statement

[clemrock]

Hello,

I'm having a problem w/ the LIMIT clause when I'm using this CASE statement.

This is working like a dream:
SELECT * FROM table ORDER BY CASE table_id WHEN 54 THEN 0 ELSE 1 END, table_id LIMIT 50

Only problem is
I would like to do a limit start, stop statement at the end rather than a

limit stop statement.

How would you do this:

SELECT * FROM table ORDER BY CASE table_id WHEN 54 THEN 0 ELSE 1 END, table_id LIMIT 50, 50

Once I add the second part of the limit, I lose the idea of displaying table_id=54 first.

Thanks a lot!

Clem