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 vote361 views2 answers
Many to many flask-sqlalchemy
SQL
1 vote318 views1 answer
MySQL AND Operator
SQL
25 votes424 views5 answers
Mysql replace text
SQL
0 vote282 views1 answer
Update sql join multiple tables
SQL
1 vote346 views1 answer
Right outer vs left outer join
SQL
14 votes359 views2 answers
Oracle limit rows
SQL
0 vote345 views1 answer
Isnull in sqlite
SQL
0 vote342 views1 answer
Sql insert from excel
SQL
0 vote335 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
15 votes330 views3 answers
Find duplicate keys in mysql
SQL