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 vote194 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
4 votes168 views1 answer
Wildcard in sql
SQL
0 vote179 views1 answer
Oracle table privileges
SQL
0 vote175 views1 answer
Delete hangfire retries list
SQL
0 vote179 views1 answer
Sql put two columns into one
SQL
0 vote177 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
3 votes179 views2 answers
Truncate table
SQL
0 vote173 views1 answer
How to see password mysql vestacp
SQL
1 vote172 views1 answer
Mysql backup skip table
SQL
7 votes152 views1 answer
Safe mode mysql
SQL