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

1 vote266 views1 answer
Alter table column size oracle
SQL
0 vote282 views1 answer
Postgresql combine values in one field
SQL
0 vote277 views1 answer
Php select data from mysql database without column name
SQL
0 vote298 views1 answer
GROUP BY postgres
SQL
0 vote344 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote280 views1 answer
Sql tablo sp
SQL
0 vote282 views1 answer
Sql use with to get value counts and percentages
SQL
3 votes275 views1 answer
Export postgres database linux
SQL
0 vote243 views1 answer
SQL server select to get sum of hours
SQL
1 vote273 views1 answer
Mysql check table exists
SQL