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

3 votes125 views1 answer
Start mysql server by terminal in linux
SQL
0 vote146 views1 answer
TSQL convert csv to table
SQL
4 votes92 views1 answer
Oracle sleep
SQL
0 vote137 views1 answer
Oracle to_number
SQL
0 vote121 views1 answer
Find largest table in mysql database
SQL
1 vote142 views1 answer
Oracle sql pad left zeros
SQL
1 vote253 views1 answer
Import sql file from laravel
SQL
8 votes123 views2 answers
Update sql server from another table
SQL
0 vote140 views2 answers
Postgresql variable in query
SQL
0 vote158 views10 answers
John the ripper mysql
SQL