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 vote174 views1 answer
Mysql offset from bottom
SQL
1 vote214 views2 answers
DROP TABLes regardless of constraints
SQL
1 vote236 views1 answer
Mysql connect bash
SQL
6 votes226 views2 answers
How to copy data in sql
SQL
1 vote213 views1 answer
Mysql Case sum
SQL
3 votes246 views5 answers
Sql select
SQL
1 vote162 views1 answer
Postgres reset auto increment
SQL
0 vote229 views1 answer
Changing name of column and datatype in sql
SQL
2 votes210 views4 answers
How to find 2nd highest salary in mysql
SQL
2 votes212 views1 answer
Mysql how to store lat,lng
SQL