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 vote368 views3 answers
Sql subquery
SQL
0 vote214 views1 answer
Remove from table where
SQL
5 votes255 views1 answer
Oracle drop index if exists
SQL
7 votes211 views1 answer
Query delete duplicates
SQL
1 vote222 views1 answer
Mysql return text after a final full stop
SQL
0 vote251 views1 answer
DATEDIFF minute postgres
SQL
12 votes251 views2 answers
Select into insert sql server
SQL
0 vote240 views1 answer
Sql statement show all emails with dome
SQL
1 vote207 views2 answers
Mysql SELECT
SQL
5 votes231 views1 answer
Find table from column name in sql
SQL