[Andrew80k]

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;