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 vote332 views1 answer
Str_to_date sql server
SQL
23 votes325 views4 answers
Sql server substring
SQL
0 vote338 views1 answer
Sql server pivot rows to columns
SQL
1 vote323 views2 answers
List tables sqlalchemy
SQL
0 vote388 views1 answer
Mysql convert charset
SQL
0 vote312 views1 answer
Sql query to select records entered in last 24 hours
SQL
17 votes384 views4 answers
Show all tables in oracle
SQL
0 vote348 views1 answer
Oracle NLS_CHARACTERSET
SQL
1 vote333 views2 answers
Mysql allow remote connections
SQL
3 votes329 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL