mysql 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,...);#filter in MySQL:
WHERE id_field not in ('817','803','495')UPDATE table
SET available=1
WHERE available=0
AND id NOT IN (id1, id2, id3,...);