I have a table containing the fields group_id and group_type and I want to query the table for all the records having any tuple (group id, group type) from a list of tuples. For example, I want to be able to do something like:
WHERE (group_id, group_type) IN (("1234-567", 2), ("4321-765", 3), ("1111-222", 5))
WHERE group_id + STR(group_type, 1) IN ("1234-5672", "4321-7653", "1111-2225")
Why not construct the OR statements?
SELECT * FROM mytable WHERE (group_id = '1234-567' and group_type = 2) OR (group_id = '4321-765' and group_type = 3) OR (group_id = '1111-222' and group_type = 5)
Granted, it doesn't look as nice and neat as your concept example but it will do the job (and if you
IN with tuples did exist, it would implement it exactly the same way under the covers most likely.