This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
May 23, 2011 3:12pm
Subscribe [2]#1 / May 23, 2011 3:12pm
Hello again,
I need to replace a word in 160 channel entries. Replacing in the entry titles went well but it seems the replacement in the rul titles is not supported in “Search and Replace”. What would be the best way to achieve this? (The website is not live yet, so changing the urls is not an issue.)
Thanks for a tip,
Wolfram
#2 / May 23, 2011 5:05pm
Hi, Wolfram.
Is it a simple word replacement? Can you give us an example?
#3 / May 23, 2011 5:28pm
Yes, Sue,
it´s one word that has to be replaced in all those url titles and all in one channel, along these lines:
“Service-...” -> “Servicecenter-...”
#4 / May 23, 2011 5:37pm
I’d make a backup of your exp_channel_titles table, and do a replace query.
Here’s a generic example:
http://www.mydigitallife.info/how-to-find-and-replace-text-in-mysql-database-using-sql/
Does that help?
#5 / May 23, 2011 6:13pm
Yes, it did 😊
Once again, thank you for your quick help!
Wolfram
#6 / May 23, 2011 10:28pm
Yay! Glad that worked for you. If anything else comes up, please do let us know in a new thread..