查出 谁读了什么书 举例子
先使用 查出对应关系
SELECT
u.NAME,
b.bookname
FROM
users u
LEFT JOIN books b ON FIND_IN_SET(
b.bookid,
u.bookIds
)
然后分组统计
SELECT
t.NAME,
GROUP_CONCAT( t.bookname ) bookNames
FROM
( SELECT u.NAME, b.bookname FROM users u LEFT JOIN books b ON FIND_IN_SET( b.bookid, u.bookIds ) ) t
GROUP BY
t.NAME