Now this is UNTESTED and since I don't have the table definitions in front of me I can't guarantee that this is correct. This is the syntax for updating a range.
UPDATE npc_types SET HP = 10 WHERE LEVEL >= 1 and LEVEL <= 10;
Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.