mysql not in list
snippet in sql

mysql not in list

user3211

#filter in MySQL:
WHERE id_field not in ('817','803','495')

mysql update where not in list

user2853

UPDATE table
SET available=1
WHERE available=0   
AND id NOT IN (id1, id2, id3,...);