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 vote424 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote336 views1 answer
Json not contains mysql
SQL
1 vote432 views2 answers
Coderbyte sql solutions
SQL
0 vote364 views1 answer
Rows, INSERT INTO, Returning
SQL
1 vote396 views3 answers
Read all columns of a table sql
SQL
0 vote376 views1 answer
Oracle list of long running queries
SQL
4 votes366 views3 answers
Rename table column postgresql
SQL
9 votes361 views1 answer
Mysql check date range
SQL
0 vote356 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote412 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL