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

1 vote147 views10 answers
Stack overflow
SQL
2 votes150 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote155 views1 answer
Oracle cpu metric
SQL
0 vote152 views2 answers
Connect to mysql server mac terminal
SQL
2 votes142 views1 answer
Plsql block
SQL
0 vote141 views1 answer
How to use query in nosql
SQL
0 vote147 views1 answer
Set a default value for a column in sqlite
SQL
2 votes174 views3 answers
Postgres json to string
SQL
3 votes152 views1 answer
V$session not found in oracle
SQL
0 vote144 views1 answer
Create table sql generator
SQL