Code:
select npc_types.id, npc_types.name, spawn2.zone, spawn2.spawngroupid
from npc_types, spawn2, spawnentry
where spawnentry.npcID = npc_types.ID
and spawnentry.spawngroupid = spawn2.spawngroupid;
This way you can see what npcid is part of what npcgroupid and than you do something like:
update spawn2
set respawntime = xx
where spawngroupid = xx
or spwngroupid = xx
or ......;
If you want to be more specific in the select command and just see npcs in one zone:
Code:
select npc_types.id, npc_types.name, spawn2.zone, spawn2.spawngroupid
from npc_types, spawn2, spawnentry
where spawnentry.npcID = npc_types.ID
and spawnentry.spawngroupid = spawn2.spawngroupid
and zone = 'zoneshortname';
Keep in mind you can NOT edit the query in MySQL-front due to the results being from multiple tables.