数据库是MySQL数据库,我想把我查出来的数据里面包含一二三,我想把一二三转换成数字的一二三如何实现。 SELECT distinct a.department AS 部门, b.dealings_abbreviation AS 供应商, a.business_manager_name AS 负责人, a.consignment_date AS 发货日期, a.weight AS 重量 FROM bm_shipment_quantity a left join bd_current_unit_alias b on a.supplier=b.id group by a.department,b.dealings_abbreviation,a.consignment_date ORDER BY find_in_set('a.department','1,2,3') ASC 主要是想把业务部排个序,现在的这个写法在页面上显示的是业务三二一这么个顺序 |