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 vote280 views1 answer
Oracle sql date summer time
SQL
3 votes271 views1 answer
If 0 return null else return query mysql
SQL
0 vote294 views1 answer
Pl/sql loop example
SQL
1 vote307 views2 answers
Mysql filter by date mount
SQL
7 votes317 views3 answers
Foreign key oracle
SQL
0 vote289 views1 answer
Replace sqlalchemy
SQL
0 vote325 views1 answer
Sql log file inof
SQL
1 vote311 views1 answer
Sometimes i cant edit sql developer
SQL
5 votes355 views3 answers
Sql limit offset
SQL
0 vote400 views1 answer
Sqlite display data in separated columns
SQL