query help

[shadowkiller990]

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

[hio77]

dropitemrule has a range of itemid locations, item0~item14

the sql would be like this

delete from cq_dropitemrule where item0 = 1020150

[shadowkiller990]

Originally Posted by hio77

dropitemrule has a range of itemid locations, item0~item14

the sql would be like this

delete from cq_dropitemrule where item0 = 1020150

thanks