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 vote145 views2 answers
Close external port 3306 with iptables
SQL
0 vote139 views1 answer
Closure in sql
SQL
5 votes126 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote149 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
9 votes136 views2 answers
Nosql databases
SQL
0 vote168 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
4 votes168 views3 answers
Postgres drop all tables
SQL
1 vote133 views1 answer
Store select query result in variable sql server
SQL
2 votes209 views1 answer
Mysql create user with remote access
SQL
0 vote221 views1 answer
Install ms sql server management studio
SQL