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 votes306 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote317 views1 answer
Primary key multiple
SQL
0 vote305 views1 answer
Sql select lowest value row
SQL
3 votes299 views1 answer
Stpop start psql server
SQL
1 vote302 views1 answer
Oracle select first result
SQL
2 votes342 views1 answer
Drop all foreign key constraints mysql
SQL
-1 vote290 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote276 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote291 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote276 views1 answer
Access refused mysql xampp server
SQL