How to generate ?

Question

Hello everyone,
I need to execute 100 queries in phpadmin as:
1. Select * from X where y=38
2. Select * from X where y=12
.......
100. Select * from X where y= 24

I have db with thousands of rows and I am trying to find way to generate queries. Can you suggest me some resources or ideas how to generate queries by script or program or maybe online platform that can help

Answer 1

Hi and what about one query instead 100? :
Select * from X where (y=38 or y=12 or ... y=24)
Or you need exactly one result of select?