Feb 27
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
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
March 10th, 2008 at 8:28 am
Very NIce