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

3 votes134 views2 answers
Mysql import gz
SQL
3 votes82 views2 answers
Coalesce mysql
SQL
1 vote121 views2 answers
Datetrunc hour snowflake
SQL
0 vote129 views1 answer
Oracle show grants on table
SQL
7 votes133 views2 answers
Postgres concat
SQL
0 vote130 views3 answers
Mysql keyword search
SQL
0 vote111 views1 answer
Default column value in sql same as other column
SQL
0 vote133 views2 answers
Unique key
SQL
0 vote115 views1 answer
Sql offfset
SQL
0 vote105 views1 answer
Oracle tablespace autoextend
SQL