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

2 votes208 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote210 views1 answer
Odd record sql query
SQL
3 votes197 views2 answers
Plsql print
SQL
0 vote220 views1 answer
Mysql dump with table query
SQL
0 vote197 views2 answers
How to find max and min salary in sql
SQL
0 vote216 views1 answer
Python mysql show databases
SQL
0 vote197 views2 answers
Postgresql get long running queries
SQL
1 vote281 views1 answer
Sql and
SQL
0 vote236 views1 answer
Site:av.ru "files"
SQL
0 vote157 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL