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

0 vote331 views1 answer
How to put value in parameters in mysqldataadapter
SQL
1 vote368 views1 answer
Tsql replace value in json
SQL
0 vote360 views1 answer
How to install sql in anaconda
SQL
0 vote367 views1 answer
Get last inserted primary key
SQL
0 vote329 views1 answer
Oracle db get table sizes
SQL
0 vote331 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
23 votes333 views3 answers
Mysqldump
SQL
1 vote321 views1 answer
Create table variable in sql stored procedure
SQL
0 vote348 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
2 votes333 views1 answer
Compare date in sql
SQL