foo,1
boo,2
goo,3

SELECT * FROM [table] WHERE
(column1 = 'foo' AND column2 = 1) OR
(column1 = 'boo' AND column2 = 2) OR
(column1 = 'goo' AND column2 = 3);

SELECT  *
FROM    foo
WHERE   (column1, column2) IN (('foo', 1), ('bar', 2))

SELECT  *
FROM    foo
WHERE   ROW(column1, column2) IN (ROW('foo', 1), ROW('bar', 2))