ok the thing is if i use the regular on item one line thing i will have to do it just over 3 thousand times so i was wondering if there is a way to shorten this by updating more then one thing at a time like i have tried this and no luck
anyone got a way of doing this or not?Code:UPDATE vendors SET extended_cost = 2 WHERE item = '33203','33471','32340','32341','32570','32573','32608','33357','31329','33283','20648','22679','28670','30050','30894','32239','32250','32263','32271','32280'