mysql update where not in code example
Example: mysql update where not in list
UPDATE table
SET available=1
WHERE available=0
AND id NOT IN (id1, id2, id3,...);
UPDATE table
SET available=1
WHERE available=0
AND id NOT IN (id1, id2, id3,...);