表关联查询时，因为有一个中括号，导致查出来的数据不全，如何在不改变原表数据的情况下（删除中括号），查询出所有的数据

您好，我试了一下，报错了，说语法错误，麻烦请教一下，这是哪里错了，感谢

SELECT
u.id,
u.名称,
GROUP_CONCAT( b.名称 SEPARATOR “ - “ ) AS ‘爱好名称’
FROM
u
LEFT JOIN b ON find_in_set (
b.id,
TRIM (
TRAILING ‘]’
FROM
TRIM ( LEADING ‘[‘ FROM u.爱好 Id )))
GROUP BY u.id;

SELECT
u.id,
u.username,
GROUP_CONCAT( b.name SEPARATOR " - " ) AS '爱好名称'
FROM
u
LEFT JOIN b ON find_in_set (b.id,  TRIM( TRAILING ']' FROM TRIM( LEADING '[' FROM u.fav_id)) )
GROUP BY u.id;