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

20 votes106 views6 answers
Change password in mysql
SQL
9 votes119 views3 answers
Import DB through mysql console
SQL
23 votes97 views6 answers
How to create table in sql
SQL
1 vote118 views1 answer
Import mysql dump database command line linux
SQL
0 vote97 views10 answers
Sql statement checker corrector
SQL
0 vote102 views1 answer
Default column value in sql same as other column
SQL
15 votes100 views2 answers
How to know the username of postgresql
SQL
1 vote109 views1 answer
How to update date add hours in postgresql
SQL
0 vote134 views1 answer
How to get table current identity value in sql server
SQL
0 vote99 views1 answer
Mysql database hyphen
SQL