mysql update where not in list

Solutions on MaxInterview for mysql update where not in list by the best coders in the world

showing results for - "mysql update where not in list"
Ian
19 Aug 2018
1#filter in MySQL:
2WHERE id_field not in ('817','803','495')
3
María Alejandra
30 Aug 2019
1UPDATE table
2SET available=1
3WHERE available=0   
4AND id NOT IN (id1, id2, id3,...);
5