View Single Post
  #8  
Old 07-23-2007, 03:58 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
You could use SQLite to update the database, something like:

BEGIN;
UPDATE Item SET ItemTitle = substr(ItemTitle, 11, 1000) WHERE ItemTitle LIKE 'ebay.co.uk%';
UPDATE ItemAttribute SET Value = substr(Value, 11, 1000)
WHERE AttributeID = 5 AND Value LIKE 'ebay.co.uk%';
COMMIT;

http://www.kinook.com/Forum/showthre...?threadid=2825
Reply With Quote