1.替换，拼接
REPLACE ( group_concat( DISTINCT ROUND( c.area) ORDER BY
c.area ), ',', '/' )
2.FIND_IN_SET查询
SELECT
a.*,
REPLACE (
group_concat(b.policy_name),
',',
'、'
) AS buildingNames FROM ff_server_activity_manage a, ff_server_preferential_policy b WHERE FIND_IN_SET(b.id, a.policy_ids) GROUP BY a.id
3.拼接字符串
CONCAT('#',fsbi.building_name ,'-',fshm.unit_no,'-' ,fshm.room_number) AS "housingResource",
4.MySql逗号拼接字符串查询的两种方法
下面两个函数的使用和FIND_IN_SET一样,使用时只需要把FIND_IN_SET换成FIND_PART_IN_SET或FIND_ALL_PART_IN_SET
例如某字段里是为1,2,3,4,5
使用方法:
第一种,传入1,3,6 可以查出来
select * from XXX where FIND_PART_IN_SET('1,3,6','1,2,3,4,5')
第二种,传入1,3,6 查不出来
select * from XXX where FIND_ALL_PART_IN_SET('1,3,6','1,2,3,4,5')
