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

0 vote255 views1 answer
Postgresql remove new line from string
SQL
1 vote191 views1 answer
Mysql datetime with timezone offset
SQL
2 votes196 views1 answer
Oracle kill job by sid
SQL
0 vote171 views1 answer
Mysql select top 2
SQL
13 votes213 views4 answers
What is sql
SQL
0 vote234 views1 answer
Java spring boot connect to sql server
SQL
29 votes201 views5 answers
Mysql show table structure
SQL
1 vote192 views2 answers
Mysql trim whitespace
SQL
0 vote200 views1 answer
Apache Derby: Create SQL Dump with data
SQL
1 vote193 views1 answer
Mysql get character set
SQL