[Gnowm]

Would searching the lore column for the value 'for the
use of anyone willing to take up arms' (or something close)
find all defiant gear.

Thats just memory, n im not even good at sql but that sounds logical.