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 vote179 views1 answer
ORA-00942
SQL
11 votes116 views2 answers
Safe mode off mysql
SQL
1 vote118 views1 answer
Install postgresql on raspberry pi
SQL
0 vote113 views1 answer
Convert .mdf to .bak
SQL
0 vote124 views1 answer
Create dump file mysql workbench
SQL
0 vote153 views1 answer
Sql alchemy escape ; in insert statement
SQL
1 vote111 views1 answer
Md5 encryption for existing records
SQL
11 votes98 views1 answer
Oracle view ddl
SQL
0 vote116 views1 answer
Oracle running queries sql
SQL
0 vote101 views1 answer
Grepper sql workbench download
SQL