I don't know if this is the correct section for SQL Requests. if not then please just move it because i could not find any request section for TrinityCore.
I Want to find an SQL Code that will select EVERY NPC from 1 raid. i dont know how i should explain this. but i want an SQL Query that selects all NPC Entry from 1 Raid.
so it should be something like this:
so it needs to be like every NPC in 1 Raid have this unique value from some column.Code:SELECT entry FROM sometable WHERE somecolumn = "Value Here";
ofc... i can just go ingame and do .npc info.
but if i do that it will take a damn long time so i was thinking about an SQL Query that finds all Entry ID's in just 1 simple query.
i have no idea if it exists but that would make it x10 times faster for me to upgrade an instance.