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 vote139 views2 answers
Mysql disable foreign key checks
SQL
6 votes106 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote159 views1 answer
How to display value of variable in mysql
SQL
8 votes139 views1 answer
How to remove tables from postgresql
SQL
1 vote141 views1 answer
Select statement to print longest name
SQL
0 vote158 views1 answer
Sql server concat null
SQL
20 votes156 views1 answer
Sql change column types
SQL
0 vote147 views1 answer
Wp_query raw sql
SQL
2 votes171 views3 answers
Sql server: how to concatenate column data using comma
SQL
2 votes189 views1 answer
Mysql now format
SQL