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 vote251 views1 answer
Sql find gaps in date ranges
SQL
0 vote237 views1 answer
Mysql remove last character
SQL
0 vote227 views1 answer
Execute sql stored procedure in powershell
SQL
4 votes227 views2 answers
Sql table
SQL
1 vote188 views1 answer
Ms sql how to see active job current run time
SQL
0 vote237 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote234 views2 answers
Suse stop MySQL
SQL
7 votes258 views2 answers
Phpmyadmin change password
SQL
1 vote244 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
10 votes228 views1 answer
Create table oracle
SQL