Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 9th, 2012  |  syntax: None  |  size: 0.84 KB  |  hits: 20  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How to return multiple rows when compared to multiple values?
  2. |  UserID  |  QuestionID  |  GameID  |
  3.   |  1       |  30          |  2       |
  4.   |  1       |  30          |  3       |
  5.   |  2       |  30          |  4       |
  6.   |  3       |  30          |  2       |
  7.   |  4       |  30          |  3       |
  8.        
  9. Select userID
  10. from table
  11. where gameID in (1,2,3,4)
  12. group by UserID
  13. having count(GameID) = 4
  14.        
  15. SELECT p.* FROM poll AS p WHERE p.UserID = <your_user_id> AND p.GameID IN (1,2,3,4)
  16.        
  17. SELECT p.*, GROUP_CONCAT(p.GameID) FROM poll AS p WHERE p.UserID = <user_id> GROUP BY p.GameID
  18.        
  19. WHERE colname = value1 OR colname = value2 ...
  20.        
  21. WHERE colname = In (value,value...)
  22.        
  23. SELECT
  24.   UserID
  25. FROM (
  26.   SELECT
  27.     UserID,
  28.     GROUP_CONCAT(GameID ORDER BY GameID) as Games
  29.   FROM some_table
  30.   GROUP BY UserID
  31. ) AS baseview
  32. WHERE Games="1,2,3,4"