Answers for "mysql update where not in list"

mysql not in list

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

Posted by: Guest on November-20-2020

mysql update where not in list

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

Posted by: Guest on November-28-2020

Code answers related to "mysql update where not in list"