I am building an UPDATE query at run-time and one of the fields I want to include in the WHERE condition may repeat several times, I do not know how many.
UPDATE table1 SET field1 = "some value" WHERE (field2 = value_1 OR field2 = value_2 OR .....OR field2 = value_n) I build such a query using a programming language and, after that, I execute it. Is this a good approach to build such a query? Respectfully, Jorge Maldonado