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 vote193 views1 answer
Oracle search in date columns
SQL
0 vote203 views1 answer
Mysql trigger to delete old data
SQL
0 vote253 views1 answer
Run docker container with database as rds metabase
SQL
0 vote175 views1 answer
Print orcale
SQL
0 vote197 views1 answer
Output table plsql
SQL
0 vote215 views1 answer
How to select only a certain date sql
SQL
5 votes204 views1 answer
Get column name sql server
SQL
0 vote195 views1 answer
Enable sql server full text indexing
SQL
5 votes195 views1 answer
Oracle list days between two dates
SQL
10 votes180 views1 answer
How to import database in mysql by cmd
SQL