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

3 votes327 views4 answers
Show sql server database
SQL
1 vote395 views1 answer
How to see logical reads in sql server
SQL
3 votes406 views2 answers
Update part of a string in mysql
SQL
1 vote362 views1 answer
Mysql check if string contains comma separated
SQL
4 votes337 views2 answers
Dbms_scheduler stop job
SQL
0 vote337 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote355 views1 answer
WHERE not regex in SQL
SQL
3 votes380 views1 answer
Laravel database Using Named Bindings
SQL
0 vote352 views1 answer
Show database not empty tables postgres
SQL
0 vote418 views1 answer
Wordpress make wp user in db
SQL