Help with code to remove a list of loot drops.
			 
			 
			
		
		
		
		I am looking for a way to remove a large list of items from the lootdrop tables so each time I update the database, I can run this script/command.  An example is, currently, non-visible defiant gear was left in the loot drops (ie. Combatant's and Adept's), while visible gear was removed and added to global loot (ie. Crude Defiant, Simple Defiant, etc.).  I want to finish removing those and will add those manually to global as well.  
 
I read around the forums, and found a way to search for a word or phrase, it would list all matching items in Heidi and in turn, I would have to manually select and delete all offending items.  If possible, I would like it to automatically delete all from a list I create. 
 
Is there a reasonable way of doing this? 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 |