笨办法:
绝对可行CREATE TEMPORARY TABLE MyTempTable (count int,userID varchar(20));
INSERT INTO MyTempTable SELECT count(*),user_id
FROM table_name group by user_id;
select * from MyTempTable WHERE count=3
绝对可行CREATE TEMPORARY TABLE MyTempTable (count int,userID varchar(20));
INSERT INTO MyTempTable SELECT count(*),user_id
FROM table_name group by user_id;
select * from MyTempTable WHERE count=3
SELECT COUNT(user_id) AS count, user_id, name
FROM table_name
GROUP BY user_id HAVING count = 3;呵呵,抄楼上的
应该SELECT COUNT(user_id) AS count, user_id /* 这里不要name? */
FROM table_name
GROUP BY user_id HAVING count = 3;