need help Searching DB for loot.....

[tbrownmn]

OK, I'm not sure where this thread belongs but here goes....

I'm looking for an item in my database and I'm having a hard time finding it.

there's a few people editing it and it's kind of like a scavenger hunt....lol

here's what i know.

a while ago someone added a unique item to a mob in the game. it's not a one-off thing it's a permanent drop.

It is a Custom item - no idea what slot or stats are attached to it.

It has a 100% drop rate but i do not know what mob drops it.

I don't know what zone the mob is in.

It's an item no player has found yet.

what would be the best program to show me all the items with 100% drop rates and which mob they drop off.....some filtering ability would be nice, there are five pages in Navicat with 100% drop items lol im trying to avoid #fi on every single entry. there are also over 400 zones to check if i use georges tools and show all items in zone....so im just looking for a faster way to filter my search. any help would be appreciated.

[Edit] Say i figure out the name of the item or the item ID. what tool can i use to find all the mobs that drop that particular item?