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 vote95 views1 answer
Oracle DROP PROGRAM
SQL
3 votes108 views1 answer
Oracle user quota on tablespace
SQL
0 vote107 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote95 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
36 votes96 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote108 views1 answer
Incorrect string value: mysql
SQL
0 vote108 views1 answer
Reona
SQL
9 votes111 views4 answers
Mysql set id auto increment
SQL
1 vote104 views1 answer
Mariadb case switch
SQL
1 vote107 views1 answer
Random name function in mysql for nvarchar
SQL