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 vote266 views2 answers
Show slave status mysql
SQL
0 vote291 views1 answer
Cross apply top for each row t1
SQL
6 votes276 views4 answers
How to remove unique key in mysql
SQL
2 votes286 views2 answers
How to check database username and password in postgresql
SQL
1 vote280 views1 answer
Does insert into overwrite sql
SQL
0 vote289 views2 answers
Search stored procedures
SQL
11 votes305 views2 answers
Having clause in sql
SQL
3 votes274 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
-1 vote294 views4 answers
Postgres between dates
SQL
3 votes293 views2 answers
Postgres inner join vs join
SQL