decode(expr, search1, result1, search2, result2, …, default)
相当于java中的switch或者sql中的case when
-- decode()
SELECT DECODE(gender, 1, '男', 2, '女', '其他') AS sex FROM users;
-- case when
SELECT CASE gender WHEN 1 THEN '男' WHEN 2 THEN '女' ELSE '其他' END AS sex FROM users;