SELECT
GROUP_CONCAT( hor.etyma_category_cn_name SEPARATOR ' | ' ) as path
FROM
et_category hor
WHERE
id IN (
SELECT
a.curr_id
FROM
(
SELECT
@id AS curr_id,
( SELECT @id := GROUP_CONCAT( pid ) FROM et_category WHERE FIND_IN_SET( id, @id ) ) AS p_ids,
@l := @l + 1 AS LEVEL
FROM
et_category,
( SELECT @id := '1456430649043390465', @l := 0 ) b
WHERE
@id IS NOT NULL
AND @id != ''
ORDER BY
LEVEL DESC
) a
)
mysql递归向上查询并且将所有结果拼接到一起
最新推荐文章于 2024-07-17 20:41:49 发布