mysql 相交

我是 mysql 新手，所以请友善。我的脚本出现以下错误，我不确定它出了什么问题。

SELECT uoid 
FROM mint 
WHERE mint_id='6' and userid='3836'
INTERSECT 
SELECT id as uoid
FROM cats 
WHERE category='Health, Fitness' 
ORDER BY 1;

gives

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERSECT SELECT id as uoid FROM cats WHERE category='Health, Fitness'' at line 4

MySQL 没有 INTERSECT 关键字。看这个问题 and this one有关如何实现您所追求的目标的建议。