View Single Post
  #2  
Old 04-04-2004, 05:34 PM
smogo
Discordant
 
Join Date: Jan 2004
Location: 47
Posts: 339
Default

for a start, you may want to use the following SQL queries :

Code:
delete from merchantlist using merchantlist, items where merchantlist.item=items.id  and items.cost > 100000;
will remove all entries in merchant list where item cost is above 100000

and
Code:
delete from merchantlist using merchantlist, items where merchantlist.item=items.id  and items.name like '%Paineel%';
will get you rid of entries in merchant list where name contains Paineel.

i hope this can save you time
Reply With Quote