CODEWITHSUNDEEP
mysqlconditional-statements
xpepermint
xpepermint

Reputation: 36243

MySQL IN condition limit

Hey, I have to use IN condition in my MySQL statement with a large set of ids.

Example

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

Is there a limit if items the IN statement can have?

Upvotes: 129

Views: 97789

Answers (3)

Progman
Progman

Reputation: 19546

No there isn't, check the manual about the IN function:

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

Upvotes: 150

praveen
praveen

Reputation: 370

enter image description here

1073741824 This is the limit given in Mysql docs

Upvotes: 4

Sachin Shanbhag
Sachin Shanbhag

Reputation: 55489

As far as I know in mysql, there is no limit for items in the IN statement.

In oracle altough, there is a limit of 1000 items in the IN statement.

But more the items in IN, your query performance will slow down unless that column is indexed.

Upvotes: 25

Related Questions