SQL Query Help

[buddysievers]

hi again, i have no idea where to post this else so i do it here.
i wonder if anyone can help me out with an sql query since i have just basic knowledge.
i want to set all weapon delays in the item_weapon table to 50%.
so is there a query for doing that or maybe an other way to do that without editing them by hand?
also it would be nice if they should only be set to 50% when they are in a specific range.
as example all weapons with an delay under 120~ and over 480~ should not get modified.
hope anyone can help me out!

[kjLotus]

update item_weapon set delay = delay/2 where delay >= 120 and delay <= 480

[buddysievers]

thank you so much kj!