Is there an alternative for WHERE IN?

Question

MySQL

Hello! The API structure assumes the possibility of obtaining users by their ID. Just like the VKontakte API https://vk.com/dev/users.get
But how to implement this on the server side?
This is the only method that comes to mind. because IDs are already written separated by commas. Making a request:

SELECT * FROM `users` WHERE `id` IN(12233456, 11235488, 4521233546,.....)

But this is probably not the right approach? What if there are too many IDs?

Answer 1

right. limit the quantity, as VK does, if you carefully read the documentation. don't forget to protect yourself from sql injections