MySQL IN constraint

Question

Hey, I need to use the IN clause in my MySQL statement with a large set of identifiers.

Example

SELECT * FROM users WHERE id IN (1,2,3,4...100000) 

Is there a limit if elements that an IN operator can have?

Answer 1

No, there is no instruction about the IN function :

The number of values ​​in the IN list is limited only by the value max_allowed_packet .

Answer 2

As far as I know in mysql, there are no restrictions for elements in an IN statement.

In the oracle, in the expression IN there is a limit of 1000 elements.

But with more elements in IN , the performance of your query will slow if the index is not indexed.

Answer 3

1073741824 This is the limit specified in Mysql docs.