Mysql Qurry help

[CDWriter]

oo Iam sorry ...but thanks for the code Kokokoul

SELECT * FROM t_npc_regen WHERE a_npc_idx = 1;

This works but the query u gave helped alot ..... for anyone who need this ....

 

Kokokoul woulds it be hard for a querry to pull npc item drops based of the item itself  , lets say i want to see where (25) Apprentice Tiara

 may drop from what npcs ?

 

Does not work 

SELECT * FROM t_npc WHERE a_item_* = 1;