Is there a query like WHERE `id` = `1`,`2`,`3`,`4`,`5` ?

Question

PHP

Is there a query in mysql like SELECT `name` FROM `user` WHERE `id` = `1`,`2`,`3`,`4`,`5`;
Or is it necessary to sort through the entire array in a cycle in php with requests?
or maybe it's better to choose all the names in general (of which there will be few of course, but suppose that there are at least a thousand of them) and then compare?

Answer 1

IN
WHERE `id` IN ('1', '2', '3', '4', '5')