Replace a string in MySQL using PHPMyAdmin

Question

I have a database for my eCommerce site, I am looking to remove the a the category out of the products field. I can do it manually using:

UPDATE  `master_database`.`products` 
SET  `product_name` =  'Xperia Z' 
WHERE  `products`.`product_id` =5107;

So I've removed the word "Sony" out like this but how would I remove "Sony" out of all of the rows that have them in the products table?

Mureinik · Accepted Answer · 2015-03-08 21:25:50Z

1

You could use replace:

UPDATE `master_database.products` 
SET    `product_name` = REPLACE (`product_name`, 'Sony ', '')

answered Mar 8, 2015 at 21:25

Mureinik

316k54 gold badges399 silver badges405 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1