求教：MySQL 随机查询10条数据，某类型要有2条

Question

根据questionType查询，1001两条，1002 四条，1003四条

Answer 1

SELECT m.* FROM (SELECT * FROM table WHERE questionType = '1001' LIMIT 0,2) m
UNION
SELECT n.* FROM (SELECT * FROM table WHERE questionType = '1002' LIMIT 0,4) n
union
SELECT n.* FROM (SELECT * FROM table WHERE questionType = '1003' LIMIT 0,4) n