MySQL and PHP search for a string in a table but replace another string

Question

So basically what i'm trying to do is search inside a table called "product_description" find the row 'name' and inside name search for the string Energy.

Lets say i have a product called Energy drink from America. I know how to search for Energy and to replace it:

$sql = "UPDATE product_description SET name = REPLACE(name, 'Energy', 'Best Energy')";

Is there a way to search for Energy and replace America with Europe?

update ... set foo=replace(...) where foo like '%America%'? — Marc B
– Marc B, Commented May 7, 2015 at 14:36
In geopolitical terms, America cannot be replaced, not by Europe. That won't ever happen. — spencer7593
– spencer7593, Commented May 7, 2015 at 14:41

AbraCadaver · Accepted Answer · 2015-05-07 14:38:14Z

2

Just use a WHERE clause with LIKE:

UPDATE product_description
    SET name = REPLACE(name, 'America', 'Europe')
        WHERE name LIKE '%Energy%'

answered May 7, 2015 at 14:38

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

Collectives™ on Stack Overflow

MySQL and PHP search for a string in a table but replace another string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related