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 vote144 views3 answers
Drop multiple columns in sql
SQL
0 vote157 views1 answer
TSQL convert csv to table
SQL
8 votes158 views1 answer
Mysql restore database
SQL
0 vote88 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
2 votes134 views1 answer
Oracle calculated column
SQL
0 vote212 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
17 votes185 views2 answers
How to assign date field for table in mysql
SQL
2 votes136 views2 answers
Sql first character
SQL
2 votes138 views1 answer
Oracle drop table free up space
SQL
0 vote159 views1 answer
Function plsql
SQL