To get records having any of the given ids
id
select * from products where id in (1,8,3)
The query above is equal to
select * from products where id = 1 or id = 8 or id = 3