Replace Title Name

General Forums General Questions
#1

Hi

Can help me somebody with one line code ?

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

THanks

Cs-Cart Rullzzzzz

#2

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

https://www.youtube.com/watch?v=snkgV7X_xI4

#3

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.

https://help.dreamhost.com/hc/en-us/articles/214395738-phpMyAdmin-How-to-backup-or-export-a-database-or-table