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

4 votes158 views2 answers
Oracle drop job
SQL
0 vote304 views2 answers
Create fulltext index mysql
SQL
16 votes152 views4 answers
Sort by sql
SQL
0 vote157 views2 answers
Postgres another version
SQL
1 vote164 views1 answer
Sqlalchemy order_by
SQL
1 vote143 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote195 views1 answer
Homebrew install mysql
SQL
2 votes157 views1 answer
Date_format for time sql
SQL
0 vote143 views1 answer
Sqlite3 now
SQL
11 votes169 views5 answers
Sql server reset identity
SQL