MySql string replace query not working

Question

If I run this query I get back several rows:

SELECT * FROM `wp_posts` where `post_content` like '%http://www.youtube%'

However when I run the query below, it says 0 rows effected.

UPDATE `wp_posts`
SET `post_content` = REPLACE(`post_content`,'%http://www.youtube%','%https://www.youtube%')
WHERE `post_content` like '%http://www.youtube%'

I am using PhpMyAdmin hosted on WP Engine. Their support say there is no restrictions on updating multiple rows.

What is wrong with the query?

Gurwinder Singh · Accepted Answer · 2017-01-31 20:16:56Z

2

Lose the % inside the replace:

UPDATE `wp_posts`
SET `post_content` = REPLACE(`post_content`,'http://www.youtube','https://www.youtube')
WHERE `post_content` like '%http://www.youtube%'

answered Jan 31, 2017 at 20:16

Gurwinder Singh

39.7k6 gold badges62 silver badges87 bronze badges

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

1 Comment

Guerrilla Over a year ago

Thanks. So obvious yet I didn't see it. I'll accept soon as timer runs out.

Collectives™ on Stack Overflow

MySql string replace query not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related