Is there a limit on how many arguments I can pass to MySQL where clause?

Question

we need to construct a Mysql query with lots of conditions:

where userId=useIdi1 or userId=userId2 or userId=userId3....

I know I can use IN instead but just curious if there is any limit on how many parameters(arguments) we can pass to WHERE clause in MySQL?

score 4 · Answer 1 · answered May 17 '17 at 21:39

4

Yes, you can find the size with the parameter: max_allowed_packet

answered May 17 '17 at 21:39

Carlos_Mondragon

score 4 · Accepted Answer · edited May 23 '17 at 12:10

4

As far as I know there is no limit specifically to the number of conditions, but in practice there is a limit to query length.

edited May 23 '17 at 12:10

Community

answered May 17 '17 at 21:39

Uueerdo

2 Answers2