Problems w/ Case Statement

[clem c rock]

Hello,

I'm trying to select specified entries from a table and display a specific record first by it's record ID and then the rest of the selected records after that.

Here's what I'm trying so far


SELECT id, title,
CASE
WHEN id = 52 THEN 52 WHEN id != 53 THEN id
END
FROM doctor
LIMIT 0, 50

When I try this, all that's displayed is the first 50 records from the database just as if I wrote the SELECT statement like this:

SELECT id, title FROM doctor LIMIT 0, 50

Any ideas?