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

4 votes157 views1 answer
Wilayah indonesia database
SQL
0 vote172 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote179 views5 answers
Mode sql course
SQL
3 votes178 views2 answers
Postgres show table schema
SQL
1 vote179 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote180 views1 answer
Check connections to database postgres
SQL
0 vote175 views1 answer
Selecting from a view SQL
SQL
0 vote191 views1 answer
Compare subqueries oracle
SQL
0 vote196 views1 answer
Postgres - Login and connect as default user
SQL
0 vote170 views1 answer
Alter table fulltext
SQL