PHPMyAdmin Replace query values in a url

Question

I understand how to use the Replace function in MySQL to replace strings of text but when I try something like this I get 0 records updated. What am I missing?

UPDATE `pages_description` 
    SET `pages_body` = REPLACE(`pages_body`, "pages.php?pID=16&CDpath=4", "pages.php?pID=188&CDpath=0_4")

Jim Mulvaney · Accepted Answer · 2020-07-29 18:51:18Z

1

It was the ampersand! OMG I needed to use the & entity for it. pages.php?pID=16&CDpath=4 I also wanted to point out (for future reference) that you will have to change the delimiter to an unused character in PhpMyAdmin to use as is. I changed mine to a colon instead of a semicolon.

edited Jul 29, 2020 at 18:51

answered Jul 29, 2020 at 18:31

Jim Mulvaney

112 bronze badges

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

Comments

Dimich · Accepted Answer · 2020-07-29 18:24:43Z

0

Maybe it's not finding any matches? Make sure you have everything spelled correctly. You can do a search like this to see if you get any results for the contents you are trying to replace.

SELECT `pages_body` FROM `pages_description` WHERE `pages_body` LIKE '%pages.php?pID=16&CDpath=4%'

The replace function is also case sensitive, so check for that too.

answered Jul 29, 2020 at 18:24

Dimich

3591 silver badge9 bronze badges

3 Comments

Jim Mulvaney Over a year ago

It returns Zero results still, which doesn't make sense because I am looking right at the url in the source code and copy/ pasting.

Dimich Over a year ago

What is the data type for the pages_body column? Also, can you copy paste a sample entry so I can test it on my end?

Jim Mulvaney Over a year ago

I figured it out, thank you. The Pages body was using the ampersand entity in place of an actual ampersand, which is why it was not finding any matches.

Collectives™ on Stack Overflow

PHPMyAdmin Replace query values in a url

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related