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 vote135 views1 answer
Metada in sql
SQL
-1 vote145 views2 answers
Postgres autoincrement primary key
SQL
5 votes149 views1 answer
Find table from column name in sql
SQL
1 vote157 views2 answers
Sql drop multiple columns if exists
SQL
8 votes164 views10 answers
Sql
SQL
0 vote183 views1 answer
Create table as select sql server error
SQL
-1 vote145 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
2 votes100 views1 answer
Sql view column data type
SQL
0 vote152 views1 answer
Sqlite referential integrity
SQL
0 vote156 views4 answers
How to get max salary in each department in sql
SQL