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 vote149 views1 answer
Hallo
SQL
0 vote136 views1 answer
Generate sequence number in sql server
SQL
27 votes131 views5 answers
Add column in table
SQL
1 vote161 views3 answers
Reseed sql table primary key
SQL
3 votes161 views2 answers
Wp do sql query from function
SQL
0 vote146 views2 answers
Unique key
SQL
2 votes94 views1 answer
Foreign key example in dbms
SQL
0 vote140 views1 answer
Setval postgres example table id
SQL
0 vote132 views1 answer
Oracle character index
SQL
0 vote134 views1 answer
Function sum(text) does not exist postgres
SQL