Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. $ids = array(1,2);
  2. $idq = array();
  3. $q = "SELECT * FROM table_name WHERE ";
  4. foreach($ids as $id)
  5. {
  6. $idq[] = "`ID` = '" . $id . "'";
  7. }
  8.  
  9. $q .= implode(" AND ", $idq);
  10.  
  11. SELECT * FROM table_name WHERE `ID` = '1' AND `ID` = '2'
  12.  
  13. `SELECT * FROM table_name WHERE `ID` = '1'`
  14.  
  15. SELECT * FROM table_name WHERE `ID` = '1' AND `ID` = '2'
  16.  
  17. SELECT * FROM table_name WHERE `ID` = '1' OR `ID` = '2'
  18.  
  19. SELECT * FROM table_name WHERE `ID` IN (1,2,...)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement