how to delete mobs in a paticular zone

[Taelin]

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

[Callissa]

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.

[Taelin]

didnt work =/

[ylosh]

delete from spawn2 where zone="greatdivide";