How to find a specific NPC or creature in your database?

[N1k0_VE]

When walking around on your server and you see a creature or NPC, how do I find that exact creature or NPC inside my database?
Say for example I want to change a hairstyle for a specific NPC.

 

[Tommy]

When walking around on your server and you see a creature or NPC, how do I find that exact creature or NPC inside my database?
Say for example I want to change a hairstyle for a specific NPC.

Target the npc and type .npc info. Afterwards it'll prompt you with information about that npc. You should see its entryId and more. All you have to do then is run queries in your world database like:

(replace GUIDNUMBER with the creature's GUID)

SELECT * FROM creature WHERE guid='GUIDNUMBER'

(replace ENTRYNUMBER with the creature's entryId)

SELECT * FROM creature_template WHERE entry='ENTRYNUMBER'