Quote:
Originally Posted by lordnivek1
how would i write a Querry for HeidiSQL to change every number in runspeed that is greater then 0 but less then 1.25 to 1.25? the only thing i know how to do is make every number the same like this.
Code:
UPDATE npc_types SET runspeed = '1.25'
which would change every speed. |
As far as to why you would do that, I'm not sure, but here is the query (use it at your own risk):
Code:
UPDATE `npc_types` SET `runspeed` = '1.25' WHERE `runspeed` > '0.0' AND `runspeed` < '1.25';