写道
p表:
name like
钱 看书
钱 做爱
钱 游戏
李 编程
李 看书
李 游戏
赵 动漫
这样一张表,要求《同时具备》看书与游戏,二个爱好的人名?
name like
钱 看书
钱 做爱
钱 游戏
李 编程
李 看书
李 游戏
赵 动漫
这样一张表,要求《同时具备》看书与游戏,二个爱好的人名?
从简单慢慢优化 写道
SELECT `name`,GROUP_CONCAT(`like`) AS bb FROM p
GROUP BY `name`
HAVING bb LIKE '%3,4%' OR bb LIKE '%4,3%'
SELECT `name` FROM
( SELECT *
FROM p
WHERE `like`='3' OR `like`='4') t
GROUP BY `name`
HAVING COUNT(1)=2
SELECT `name`
FROM p
WHERE `like`='3' OR `like`='4'
GROUP BY `name`
HAVING COUNT(1)=2
GROUP BY `name`
HAVING bb LIKE '%3,4%' OR bb LIKE '%4,3%'
SELECT `name` FROM
( SELECT *
FROM p
WHERE `like`='3' OR `like`='4') t
GROUP BY `name`
HAVING COUNT(1)=2
SELECT `name`
FROM p
WHERE `like`='3' OR `like`='4'
GROUP BY `name`
HAVING COUNT(1)=2
??
?
?