query help

how do i delete a item id from cq_dropItemrule

like i tried

delete cq_dropitemrule 1020150

lol i know its not that simple but can someone help i just want one certain item id removed from the droprule but theres like 200 of them so was wondering if theres a way to do a query to look for everything that says this 1020150 and remove or update it to a differnt id please let me know thanks :D

dropitemrule has a range of itemid locations, item0~item14

the sql would be like this

Quote:

Originally Posted by hio77 dropitemrule has a range of itemid locations, item0~item14 the sql would be like this Code: delete from cq_dropitemrule where item0 = 1020150

thanks :D