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

3 votes415 views1 answer
Oracle cannot access v$session
SQL
31 votes310 views1 answer
Postgresql add column with constraint
SQL
1 vote303 views1 answer
Sql myisam vs innodb
SQL
0 vote315 views1 answer
Monthly Birthday SQL Query
SQL
10 votes313 views4 answers
Sql pagination
SQL
0 vote372 views1 answer
Sql query for login with email or username
SQL
1 vote321 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote301 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
5 votes320 views4 answers
Mysql on duplicate key update
SQL
6 votes343 views3 answers
How to delete table sqlite
SQL