sql替换字段内容
update 表名 set 列名 =REPLACE( 列名 ,'要被替换的字符串','替换成的字符串');
拼接字段(id1,id2,id3)-(A,B,C)
select id, room_name,capacity, application_scope, room_resources, remarks, room_status, enable,GROUP_CONCAT(org_group.name_) orgName
from ydhr_conference_room JOIN org_group
ON FIND_IN_SET(org_group.id_,ydhr_conference_room.application_scope)
GROUP BY ydhr_conference_room.id order by gmt_create