Yes, you would need to open the large database file in something like Notepad++, find the statements you're interested in, save those into a different file, drop the existing table, then source that new file.
Since you used an absolute value like that instead of something like 25% of the original there's not really a formula that will get you back to how it was before you ran the query.
To do the same thing while excluding pets you could do something like:
SET npc_types hp = level * 10 where level < 50 && id NOT IN (SELECT npcid FROM pets);
Or, if you just wanted to try changing pets to a different multiplier, something like:
SET npc_types hp = level * 50 where level < 50 && id IN (SELECT npcid FROM pets);
As always, make backups, and run your queries with a select first to make sure you're going to hit the right rows.
|