
Untitled
By: a guest on
May 9th, 2012 | syntax:
None | size: 0.84 KB | hits: 20 | expires: Never
How to return multiple rows when compared to multiple values?
| UserID | QuestionID | GameID |
| 1 | 30 | 2 |
| 1 | 30 | 3 |
| 2 | 30 | 4 |
| 3 | 30 | 2 |
| 4 | 30 | 3 |
Select userID
from table
where gameID in (1,2,3,4)
group by UserID
having count(GameID) = 4
SELECT p.* FROM poll AS p WHERE p.UserID = <your_user_id> AND p.GameID IN (1,2,3,4)
SELECT p.*, GROUP_CONCAT(p.GameID) FROM poll AS p WHERE p.UserID = <user_id> GROUP BY p.GameID
WHERE colname = value1 OR colname = value2 ...
WHERE colname = In (value,value...)
SELECT
UserID
FROM (
SELECT
UserID,
GROUP_CONCAT(GameID ORDER BY GameID) as Games
FROM some_table
GROUP BY UserID
) AS baseview
WHERE Games="1,2,3,4"