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

2 votes97 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote143 views3 answers
Mysql CAST(amount as float)
SQL
2 votes118 views1 answer
Oracle run_duration to number
SQL
0 vote107 views1 answer
Oracle get running queries
SQL
3 votes106 views1 answer
Force using index plsql
SQL
17 votes101 views4 answers
Sort by mysql
SQL
2 votes110 views1 answer
Sql server find columns list in tables
SQL
1 vote87 views4 answers
Sql now
SQL
3 votes107 views4 answers
Show databases in sql server
SQL
0 vote101 views3 answers
Above average salary in sql
SQL