If you want find an item by name SERVER-WIDE in loot tables.
(crude defiant used as example here)
Code:
SELECT le.* FROM items i
INNER JOIN lootdrop_entries le ON i.id = le.item_id
WHERE i.name like "%crude defiant%"
If you want to simply DISABLE that particular kind of item (name) from dropping SERVER-WIDE
This just simply sets it's chance of dropping to 0
Code:
UPDATE lootdrop_entries ld
INNER JOIN items i ON i.id=ld.item_id
INNER JOIN loottable_entries lt ON ld.lootdrop_id=lt.lootdrop_id
SET ld.chance = 0
WHERE i.Name like '%crude defiant%' and ld.chance > 0;