switch syntax mysql code example
Example 1: mysql switch case
mysql> SELECT CASE WHEN 2>3 THEN 'this is true' ELSE 'this is false' END;
+
| CASE WHEN 2>3 THEN 'this is true' ELSE 'this is false' END |
+
| this is false |
+
Example 2: mysql switch case
SELECT
t2.company_name,
t2.expose_new,
t2.expose_used,
t1.title,
t1.status,
CASE status
when 'New' and t2.expose_new = 1 then 1
when 'New' and t2.expose_new = 2 then 2
when 'New' and t2.expose_new = 3 then 3
when 'Used' and t2.expose_used = 1 then 1
when 'Used' and t2.expose_used = 2 then 2
when 'Used' and t2.expose_used = 3 then 3
END as expose
FROM `products` t1
join manufacturers t2 on t2.id = t1.seller
where t1.seller = 4238