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

-1 vote121 views1 answer
Count occurrences sql
SQL
0 vote125 views1 answer
How to list function in psql
SQL
-1 vote127 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote111 views1 answer
Compare field sql server
SQL
0 vote108 views1 answer
Test connection to sql server
SQL
7 votes115 views1 answer
Oracle reset sequence
SQL
6 votes125 views2 answers
Postgresql restore from dump
SQL
0 vote72 views1 answer
Mysql collation for all languages
SQL
0 vote128 views1 answer
Shortcut run sql pgadmin
SQL
6 votes105 views1 answer
Allsource oracle
SQL