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

5 votes358 views1 answer
Purge undo tablespace usage
SQL
-1 vote328 views3 answers
Mysql get age from date
SQL
1 vote370 views3 answers
Read all columns of a table sql
SQL
4 votes384 views1 answer
Mysql store ip address
SQL
0 vote331 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote318 views1 answer
Sql select most frequent value in group
SQL
11 votes329 views4 answers
Query DISTINCT
SQL
0 vote376 views1 answer
Stratified sampling sql
SQL
0 vote317 views1 answer
Date diff sql
SQL
16 votes347 views1 answer
Mssql int max value
SQL