Sql if else in select

-- In a query (DUAL is for Oracle)
SELECT CASE lower(my_col)
	WHEN 'agree' THEN 'Ok' 
	WHEN 'maybe' THEN 'Wait' 
    ELSE 'Ko' 
END AS my_result
FROM DUAL;

Similar codes

0 vote218 views1 answer
Mysql backup certain tables workbench
SQL
0 vote228 views1 answer
Delete record by id sql
SQL
0 vote197 views1 answer
Procedures and functions in pl/sql
SQL
0 vote235 views1 answer
How to run mysql on terminal mac
SQL
2 votes212 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
1 vote234 views1 answer
Postgresql pass array in function
SQL
0 vote219 views4 answers
Database stuck at restoring state
SQL
17 votes227 views3 answers
How to change a collumn name in sql
SQL
2 votes244 views1 answer
Mysql id of inserted row
SQL
9 votes239 views4 answers
Postgresql export database
SQL