I searched around and I cannot find this. But can you use a cursor.executemany() command with SELECT?
IE:
MyList = ["Value1", "Value2", "Value3", "Value4"]
SQL = "SELECT ColA FROM myTable WHERE ColA IN (%s)
cursor.executemany(SQL, myList)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I searched around and I cannot find this. But can you use a cursor.executemany() command with SELECT?
IE:
MyList = ["Value1", "Value2", "Value3", "Value4"]
SQL = "SELECT ColA FROM myTable WHERE ColA IN (%s)
cursor.executemany(SQL, myList)
Yes, but you'd get four seperate statements executed.