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 vote160 views1 answer
Apex run 404
SQL
0 vote180 views3 answers
Mysql regex replace
SQL
7 votes182 views1 answer
Query postgres delete duplicates
SQL
1 vote172 views1 answer
Mysql show current queries
SQL
2 votes167 views2 answers
Mysql limit
SQL
1 vote188 views1 answer
Postgresql not in
SQL
0 vote169 views1 answer
How to change the field size of an existing column
SQL
0 vote188 views1 answer
How to find lowest in sql
SQL
0 vote173 views1 answer
Mysql select where field like in list
SQL
0 vote177 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL