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

7 votes220 views1 answer
Mysql unsafe update
SQL
0 vote296 views1 answer
Mysl like insert a variable
SQL
0 vote253 views1 answer
Insert ip address in mysql
SQL
2 votes264 views1 answer
Oracle Column Names of a table
SQL
0 vote233 views1 answer
Oracle exchange partition
SQL
0 vote229 views1 answer
The local psql command could not be located
SQL
2 votes271 views2 answers
Null column to 0 in mysql
SQL
5 votes253 views3 answers
Postgres show databases
SQL
0 vote262 views1 answer
Run sql script file and changes db name in this file using c#
SQL
2 votes278 views1 answer
Find column in all stored procedures sql server
SQL