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 vote132 views5 answers
Linq cheat sheet
SQL
3 votes139 views4 answers
Show databases in sql server
SQL
2 votes138 views1 answer
Sqlite3 show columns name
SQL
8 votes135 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote142 views1 answer
Get cpu details sql
SQL
0 vote140 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
5 votes136 views1 answer
Oracle drop index if exists
SQL
1 vote147 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote126 views1 answer
Remove from table where
SQL
7 votes133 views2 answers
What is sql clause
SQL