0

How to generate ?

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

10th Dec 2020, 2:33 PM
Andrew Yakovlev
Andrew Yakovlev - avatar
1 Odpowiedź
0
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?
11th Dec 2020, 6:54 PM
Václav Dostál
Václav Dostál - avatar