MySQL的CASEWHEN语句的几个使用实例:使用CASE WHEN进行字符串替换处理 代码如下:mysql> select * from sales; 9 rows in set (0.01 sec) SELECT name AS Name, CASE category WHEN Holiday THEN Seasonal WHEN Profession THEN