how to delete mobs in a paticular zone
 

i am trying to find a mysql script that will delete all the mobs in the zone greatdivide, can someone help me?

delete from spawn2 where spawngroupid in (select id from spawngroup where name like greatdivide%)


Although that will only delete the actual spawnpoint assignments and leave quite some now unused trash in your database.

didnt work =/

delete from spawn2 where zone="greatdivide";