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 vote227 views1 answer
Mysql select where field like in list
SQL
1 vote232 views1 answer
How to use a trigger to validate input data
SQL
2 votes230 views6 answers
In operator in sql
SQL
2 votes206 views1 answer
Oracle sql drop column if exists
SQL
0 vote243 views4 answers
User defined function sql
SQL
0 vote255 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote255 views1 answer
Prisma transaction
SQL
1 vote255 views1 answer
Drop primary key oracle
SQL
0 vote222 views1 answer
Luu ckeditor vao mysql
SQL
3 votes219 views1 answer
Oracle failed login attempts
SQL