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 vote172 views1 answer
Postgresql append array
SQL
5 votes148 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote128 views1 answer
Sql if else in select
SQL
1 vote111 views1 answer
Avg mysql
SQL
0 vote254 views1 answer
Sqlite display data in separated columns
SQL
22 votes133 views6 answers
Create sql table
SQL
1 vote151 views1 answer
Sql server read uncommitted
SQL
0 vote185 views1 answer
Replace null value within column mysql
SQL
1 vote143 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote126 views1 answer
Sql sort ages
SQL