+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: There is some query for this? (/showthread.php?tid=564)
- Wrong - 12-30-2011
Hey guys, I need to know if there is some query to delete all mobs except the ones I dont want to delete. Lets say i dont wanna delete mobs with ID 131 and 42, how could I do it?
Regards.
- Wizatek - 12-30-2011
DELETE FROM t_npc WHERE a_index NOT IN (131,42);
- Wrong - 12-30-2011
thx, worked perfect