Thread

I’ve been trying to use EE’s Search and Replace utility to replace a complete phrase in the Channel Entry Titles (in about 70 entries, before I go live with a site). It works okay when I search and replace a custom field, but Channel Entry Titles aren’t working. I don’t get an error, but I get zero records returned/replaced.

I’m even trying to do the change via PHPMyAdmin using a query and it’s not working. I’m doing variants on a pretty basic MySQL find and replace:

UPDATE `exp_channel_titles` SET title = REPLACE (title,"Phrase to Find","Phrase I Want to Replace It With")

But I get zero rows returned.

Finding those entries works okay:

SELECT `entry_id`,`title` FROM `exp_channel_titles` WHERE `title` = "Phrase to find"

This doesn’t seem to make sense, am I just missing something special and have to change the title in a particular way that’s different?

Help is greatly appreciated 😊

Hi Oxygen Smith,

That’s strange that the search and replace isn’t working for you correctly. I just tested on my sandbox and was able to successfully change titles using the built in utility. What version of EE are you currently on? If you could upgrade to 2.4.0 and test again that would be great.

Sean

Sorry for the delay in replying Sean. I definitely want to update to 2.4 and try it, but we’re in a critical post launch period for a month.

I should really have the site on a version control system but I’m just getting my toes in the water and this is a complicated site, I don’t want to accidentally wipe out repositories, etc.

I can try it on a simpler site and get back to you later.

Thanks again.

Oxygen Smith,

Please do get back to me once you’ve had a chance to test in 2.4.

Sean