Mysql equivalent decode oracle

create procedure ora_sp_decode2 (out job_level TEXT ) 
begin 
select CASE job_lvl
WHEN 1 THEN 'level 1
WHEN 2 THEN 'level 2'
ELSE 'Unknown level' end
into job_level from employee where job_id>0   ;
end ;

Source: doc.ispirer.com

Similar codes

1 vote201 views1 answer
Add current timestamp in mysql
SQL
0 vote211 views1 answer
Check constraint is violated
SQL
0 vote190 views1 answer
Sql select inside select sub query
SQL
15 votes184 views2 answers
Open postgress in terminal mac
SQL
0 vote165 views1 answer
How to find unique key in sql
SQL
7 votes203 views3 answers
SQL create a new table
SQL
0 vote185 views1 answer
ORA-13717
SQL
3 votes186 views2 answers
Postgres show table schema
SQL
0 vote185 views1 answer
Mysql drop multiple tables at once
SQL
0 vote200 views1 answer
Mysqli last row
SQL