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

8 votes199 views1 answer
Oracle all_source package body
SQL
0 vote217 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
-1 vote200 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
3 votes211 views1 answer
Where id is in list sql
SQL
0 vote244 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote180 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
3 votes187 views1 answer
Mysql UPDate with enner join
SQL
0 vote259 views1 answer
Php insert null mysql
SQL
0 vote195 views1 answer
Mysql add to number
SQL
-1 vote201 views2 answers
Installing mysql on centos 7
SQL