We have a list of IDs, for example:
11, 22, 55, 99, 187
We have a table with a field "id".
We basically want to select ALL results where the id equals 11, 22, 55, 99, 187
What would be the best way to do a mySQL query like this?
Instead of doing WHEREid= '11' OR '22'.....
We are using this with PHP, as we have a list of IDs and are wanting to select the results using these IDs with a mysql query.
Use this
Where id IN (11,22,55,99,187)
As mentioned on other answers you can use the IN (...) clause. But if you have a long list of id values and you want the best performance, then I would suggest using a temporary table to store the values and then use an INNER JOIN on the temporary table:
/* Create the temporary table */
CREATE TEMPORARY TABLE temp_lookup (id INT NOT NULL);
/* Insert values in temp table */
INSERT INTO temp_lookup (id) VALUES (11), (22), (55), (99), (187), ...;
/* Select using INNER JOIN */
SELECT mt.field_list
FROM main_table AS mt INNER JOIN temp_lookup AS tt ON mt.id = tt.id
You can use mysql's IN-function
Something like:
SELECT id from table where id IN (11, 22, 55, 99, 187);
It's really logic, just read the manual.
