oracle:
SELECT
clause_a,
clause_b,
clause_c,
CASE
WHEN clause_d LIKE 'aaaa%' THEN CONCAT(clause_e, COALESCE(' (' || clause_f || ')', ''))
ELSE clause_e
END clause_f,
FROM
table_1
mysql:
SELECT
clause_a,
clause_b,
clause_c,
CASE
WHEN clause_d LIKE 'aaaa%' THEN CONCAT(clause_e, '(', COALESCE( clause_f ,''), ')')
ELSE clause_e
END clause_f,
FROM
table_1
注意:oracle中的“||”是连接字符串的作用,因此,在mysql中需要用concat(a,b,c)方法来进行字符串拼接,此处在sql文修改的时候很容易被忽略。