-2

I have some inquiries related to IN function in MySQL. how many variable can store within In function ?

Example:

select * from staff where id in ('1','2',......'????')

Do you have any ideas ?

Regards,

fejese
  • 4,601
  • 4
  • 29
  • 36
jam vara
  • 1
  • 1

1 Answers1

1

From the docs:

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

fejese
  • 4,601
  • 4
  • 29
  • 36