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                                               | 
+-------------------------------------------------------------+

Source: stackoverflow.com

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

Source: stackoverflow.com

Similar codes

1 vote285 views2 answers
Sql for date greater than
SQL
2 votes282 views1 answer
Oracle convert run_duration to number
SQL
0 vote282 views1 answer
Mysql regex select
SQL
1 vote291 views1 answer
Wherein mysql
SQL
3 votes281 views2 answers
Find the median in sql
SQL
27 votes285 views6 answers
Set password mysql
SQL
16 votes300 views2 answers
Mysql date between two dates
SQL
25 votes294 views6 answers
Import mysql database command line
SQL
2 votes314 views1 answer
Create mysql user on all hosts
SQL
0 vote264 views1 answer
Mysql into outfile with headers
SQL