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 vote292 views1 answer
Postgres set sequence value to max id
SQL
25 votes268 views3 answers
Mysql command show tables
SQL
0 vote273 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote258 views1 answer
MySql count occurences more than"
SQL
32 votes300 views6 answers
Insert select
SQL
0 vote289 views1 answer
Psotgres multiple values
SQL
3 votes260 views2 answers
How to View column names of a table in SQL
SQL
0 vote270 views1 answer
Cast as decimal postgresql
SQL
8 votes283 views1 answer
How to check mysql version in xampp
SQL
0 vote230 views1 answer
Jooq finding lastest value in table
SQL