表结构如下：
字典表 common_dict
订单表 work_order
现在需要把work_order表里的异常状态查询显示为汉字
SELECT w.order_no,GROUP_CONCAT(cd.label) AS abnormal_status FROM common_dict cd JOIN work_order w ON 1 =1 WHERE cd.type LIKE ‘%abno%‘ AND INSTR(w.abnormal_status,cd.`value`)> 0 GROUP BY w.order_no;
查询结果如下：
原文：https://www.cnblogs.com/huhu-xiaomaomi/p/10830950.html