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 vote263 views1 answer
Test connection to sql server
SQL
0 vote219 views2 answers
Delete the last item in a table sql
SQL
1 vote254 views1 answer
Create index concurrently postgres
SQL
0 vote256 views1 answer
Use between operator in mysql
SQL
0 vote252 views1 answer
Sql get user account
SQL
0 vote265 views1 answer
Group by sql not ordering issues
SQL
0 vote282 views1 answer
Max length found in mysql
SQL
0 vote248 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote287 views1 answer
Shrink database file in sql server
SQL
0 vote262 views4 answers
Forenkey code alchemy sql
SQL