Maximum values in wherein clause of mysql

Question

Hi friends,

Do anyone knows about how many values I can give in a where in clause? I get 25000 values in a where in clause and mysql is unable to execute. Any thoughts? Awaiting for your thoughts

Answer 1

I think that if this restriction is a problem then you're doing something wrong.

Perhaps you could store the data from your where clause in a table and then join with it. This would probably be more efficient.