lots of code take some code, share some code!

You can use a case statement in SQL like so:

SELECT
id, `name`, title,
CASE id
WHEN 2 THEN 1
WHEN 3 THEN 1
ELSE 0
END AS selectedCase
FROM table

Filed under: SQL, Snippets, SQL