Replace Title Name


Can help me somebody with one line code ?

I need to delete specific 3 characters from all title names from products. Lets said XXX


Cs-Cart Rullzzzzz

export all names to csv file then open in exel, then do a find and replace xxx, delete what isnt required then import back in

or if it isnt so many select all products then "edit" selected

Use the following MySQL command in PHPMyAdmin to search and replace all 'xxx' with no character.

update cscart_product_descriptions set product= replace(product,'xxx','');

Further help:

UPDATE `table_name` SET `field_name` = replace(same_field_name, 'unwanted_text', 'wanted_text')

I would back-up table first just in case.