MySQL LEFT JOIN on list -

i have table this:

id | val1 | val2 ---------------- 1  |  100 |  200 2  |  200 |  100 3  |  150 |  250

and api list like:

((1, 100, 200),   (2, 200, 101),  (3, 150, 250))

from list same data table, there can see column val2 id 2 has changed 100 101.

what kind of mysql query return second row of list?, is, row had 1 of values changed.

it should test both val1 , val2 columns.

you can use in() operator multiple fields list:

select * table (id, val1, val2) not in ((1, 100, 200),                                 (2, 200, 101),                                (3, 150, 250))

Brent