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

9 votes213 views2 answers
Sql server check table exists
SQL
0 vote198 views1 answer
How to check default value of column in sql server
SQL
-1 vote199 views3 answers
Update mongodb version ubuntu
SQL
0 vote192 views1 answer
Backup a table in sql
SQL
0 vote191 views1 answer
Java mysql date format
SQL
0 vote198 views2 answers
Mysql regexp match word
SQL
10 votes201 views5 answers
Between keyword in sql
SQL
0 vote199 views1 answer
Sql insert from excel
SQL
13 votes196 views2 answers
Sql join
SQL
4 votes160 views1 answer
Oracle sleep
SQL