mysql where not in list code example
Example 1: mysql not in list
#filter in MySQL:
WHERE id_field not in ('817','803','495')
Example 2: mysql update where not in list
UPDATE table
SET available=1
WHERE available=0
AND id NOT IN (id1, id2, id3,...);