SELECTID FROM .. wherevalue='本科'
INTERSECT
SELECTID FROM .. wherevalue='1年'
这不是mysql
不过,可以搜MySQL的同类函数
MySQL应该是没这个函数,但思路是求交集可以借鉴,通过以下实现:
SELECT id FROM testaa a INNER JOIN testaa bUSING(id) WHERE a.NAME='本科' AND b.name='1年';
一朋友给出另一种方法:
SELECT id, GROUP_CONCAT(name) as names FROM testaa GROUP BY id having names LIKE '%本科%' AND names LIKE '%1年%'
也可以这样:
SELECT id, COUNT(0) AS c FROM testaa WHERE NAME = '本科' OR NAME = '1年' GROUP BY id HAVING c > 1;
页:
[1]