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 vote187 views1 answer
Oracle duration between timestamps
SQL
15 votes335 views3 answers
Postgresql change column type
SQL
0 vote214 views1 answer
Mysql best varchar length size
SQL
0 vote185 views1 answer
How to use group_concat in sql server
SQL
1 vote186 views1 answer
Pl sql ptint
SQL
4 votes181 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote189 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote182 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote199 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote209 views1 answer
Into operator in sql
SQL