MySQL IN condition limit

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.

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.