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 vote342 views1 answer
Mamp mysql path mac
SQL
0 vote303 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote336 views1 answer
Drop database using terminal postgres
SQL
0 vote344 views1 answer
Recently updated stored procedure in sql server
SQL
31 votes332 views4 answers
Mysql grant execute
SQL
1 vote344 views3 answers
How to pass password to mysql command line
SQL
1 vote336 views1 answer
Write a query to create an empty table from an existing table?
SQL
2 votes343 views3 answers
Sql server reseed identity column
SQL
9 votes351 views3 answers
Where clause sql
SQL
0 vote304 views1 answer
Mysql installer no packages found
SQL