I have multiple columns which store unique, distinct identifiers that can be used interchangeably. I would therefore like to select records where either Col1 or Col2 is equal to any of a number of supplied parameters. I have tried the following, and variations, IE, where Col1 in (?, ?) or Col2 in (?, ?).
SELECT * FROM Table WHERE EXISTS (Col1, Col2) IN (?, ?);
I can currently acheive this using the following, however, it's long and unwieldy, since it repeats ? in (Col1, Col2) for each query I would like to bind.
SELECT * FROM Table WHERE ? in (Col1, Col2) OR ? in (Col1, Col2);
Ultimately, my query may have up to 1000 parameters (all will be unique), so I was wondering if there is any more natural way to do the above query?
Aucun commentaire:
Enregistrer un commentaire