mysql不支持intersect,替代方案:
SELECT * FROM
(SELECT * FROM table WHERE radius = 3) AS a
INNER JOIN
(SELECT * FROM table WHERE radius = 5) AS b
WHERE a.id=b.id
mysql不支持intersect,替代方案:
SELECT * FROM
(SELECT * FROM table WHERE radius = 3) AS a
INNER JOIN
(SELECT * FROM table WHERE radius = 5) AS b
WHERE a.id=b.id