SELECT DISTINCT
info.`id`,
SUBSTRING_INDEX(
SUBSTRING_INDEX(
info.`material_id`,
',',
b.help_topic_id + 1
),
',',
- 1
) AS material_id
FROM
(
A
) info
JOIN mysql.help_topic b ON b.help_topic_id < (
LENGTH(info.`material_id`) - LENGTH(
REPLACE (info.`material_id`, ',', '')
) + 1
)
WHERE
1 = 1
-- info.`id` = '1243360010160885760'
结果集A是:
SELECT
a.id,
a.material_id
FROM
t_goodinfo a
LEFT JOIN t_material b ON a.material_id = b.id
AND b. STATUS = 0
WHERE
a. STATUS = 0
AND LOCATE(",", a.material_id)
上面的结果集,是物料id用逗号拼接的数据