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 votes319 views1 answer
Postgres count distinct
SQL
4 votes286 views3 answers
Create database in mySQL
SQL
10 votes307 views1 answer
Oracle dba_dependencies
SQL
2 votes309 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote290 views1 answer
Java spring boot connect to sql server
SQL
14 votes305 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
6 votes368 views3 answers
What is where in sql
SQL
0 vote360 views1 answer
Reindexing all tables sql server
SQL
0 vote310 views1 answer
Oracle drop type
SQL
6 votes285 views2 answers
Mysql first day of month
SQL