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 vote178 views1 answer
Sql show all users
SQL
-1 vote173 views1 answer
Mysql extract days
SQL
0 vote161 views1 answer
How to check if there is no database schema
SQL
2 votes170 views1 answer
Date conversion in mysql column
SQL
1 vote159 views1 answer
Sql get all columns from one table but one from another inner join
SQL
11 votes163 views2 answers
Mysql disable safe mode
SQL
2 votes167 views1 answer
Oracle drop table free up space
SQL
1 vote155 views1 answer
Sql group by error
SQL
0 vote174 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
1 vote126 views1 answer
Unique vs distinct sql
SQL