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

0 vote117 views1 answer
List MySQL Table and Index Size
SQL
3 votes110 views1 answer
Locate sql server
SQL
0 vote121 views1 answer
Mysql table variables
SQL
1 vote79 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote125 views1 answer
Database traccar
SQL
0 vote108 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote125 views1 answer
Replace string in whole database mysql stackoverflow
SQL
21 votes111 views6 answers
Docker run mysql
SQL
0 vote116 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote119 views1 answer
Sql change column in existing table
SQL