Mariadb case switch

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

Similar codes

3 votes352 views3 answers
List columns in table postgres
SQL
23 votes363 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote341 views1 answer
Use where instead of join
SQL
0 vote324 views1 answer
Recursive query herarchical data sql server
SQL
49 votes440 views6 answers
Install mysql ubuntu
SQL
0 vote336 views1 answer
Get who is hired in specific month in sql
SQL
10 votes338 views2 answers
Sql rtrim
SQL
0 vote352 views1 answer
Mysql master slave setup with keepalived
SQL
1 vote345 views1 answer
Alter constraint postgres
SQL
7 votes380 views1 answer
Mysql remote connection command line
SQL