MySQL - How to select rows where value is in array?

You can use the IN operator to select rows where the value is in an array.

For example, if you have a table named users with a column named id and you want to select all rows where the id is in an array of values, you can use the following SQL query:

Example of using the IN operator to select rows where the value is in an array in MySQL

SELECT * FROM users WHERE id IN (1, 2, 3);

This will return all rows from the users table where the id column has a value of 1, 2, or 3.

You can also use the IN operator with a subquery like this:

Example of using the IN operator with a subquery in MySQL

SELECT * FROM users WHERE id IN (SELECT id FROM other_table);

This will return all rows from the users table where the id column has a value that is also in the id column of the other_table table.

When building the list of values dynamically in your application code, always use parameterized queries to prevent SQL injection.