How to do bulk replace in MySQL database?

Question

PHP

Please tell me how to delete the content from the word "iframe" to the end in the product_description table in all fields containing the word "cincopa".

Answer 1

or just download the dump database.
open with notepad ++ or sulime and replace with regexp
it all depends on the database and the specific string...

Answer 2

MySQL: INSTR + SUBSTRING + REPLACE + UPDATE ... WHERE ...

Answer 3

Specify in more detail which columns you have in the product_description table.
For one column "text" it would be like this:

UPDATE `product_description`
SET `product_description`.`text`=LEFT(`product_description`.`text`, LOCATE('iframe', `product_description`.`text`)-1)
WHERE 1
  AND `product_description`.`text` LIKE '%cincopa%'
  AND `product_description`.`text` LIKE '%iframe%'