SELECT
*
FROM
qx_area
WHERE
(FIND_IN_SET(id,‘130100,140000’)
OR FIND_IN_SET( 130100, parent_ids )
OR FIND_IN_SET( 140000, parent_ids )
OR FIND_IN_SET(id,(
SELECT
GROUP_CONCAT(parent_ids)
FROM
qx_area
WHERE
FIND_IN_SET(id,‘130100,140000’)))
)
mysql查询所有父节点和子节点
最新推荐文章于 2022-08-17 18:53:45 发布