Select from mysql table WHERE field=’$array’?

by

Use IN:

$sql = "SELECT * FROM `myTable` WHERE `myField` IN (1,40,20,55,29,48)";

you can use implode(",", $array) to get the list together from the array.

More Related Contents:

  1. Notice: Array to string conversion in
  2. Sign in form always showing "Wrong Credentials"
  3. Prevent creating duplicate entries in PHP
  4. i have stored array in database as a string how can retrieve that array?
  5. Insert array into MySQL database with PHP
  6. Sum values of multidimensional array by key without loop
  7. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  8. How can I properly use a PDO object for a parameterized SELECT query
  9. Save PHP array to MySQL?
  10. MySQL: Select Random Entry, but Weight Towards Certain Entries
  11. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  12. Selecting multiple array elements
  13. How get all values in a column using PHP?
  14. mysql select query within a serialized array
  15. PDO fetch one column from table into 1-dimensional array
  16. Selecting all columns that start with XXX using a wildcard?
  17. SELECT COUNT() vs mysql_num_rows();
  18. Get all mysql selected rows into an array
  19. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  20. How do I set the selected item in a drop down box
  21. MySQL query using an array [duplicate]
  22. Selecting all fields except only one field in mysql [duplicate]
  23. How to insert json array into mysql database
  24. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  25. select within 20 kilometers based on latitude/longitude
  26. PHP/SQL Insert Error when using Named Placeholders
  27. MySQL ORDER BY rand(), name ASC
  28. Create PHP array from MySQL column
  29. Save array in mysql database
  30. MySQL PHP – SELECT WHERE id = array()? [duplicate]

Leave a Comment