Mysql Qurry help

[CDWriter]

Solved this query works Sloppy but works.

-- Finding a Drop item from any MOb

-- Change value below of the item number to find

SET @a=603;

SELECT a_index, a_name FROM t_npc WHERE t_npc.a_item_0 = @a or t_npc.a_item_1 = @a or t_npc.a_item_2 = @a or t_npc.a_item_3 = @a or t_npc.a_item_4 = @a or t_npc.a_item_5 = @a or t_npc.a_item_7 = @a or t_npc.a_item_8 = @a or t_npc.a_item_9 = @a or t_npc.a_item_10 = @a or t_npc.a_item_11 = @a or t_npc.a_item_12 = @a or t_npc.a_item_13 = @a or t_npc.a_item_14 = @a or t_npc.a_item_15 = @a or t_npc.a_item_16 = @a or t_npc.a_item_17 = @a or t_npc.a_item_18 = @a or t_npc.a_item_19 = @a;

CLOSE TOPIC