Thread

Hi Guys

Here’s a question for anybody with advanced SQL Skills:

I’m re-branding a site I made and need to change text references of the old site to the new site.
The issue is the name of the new site is 2 words, where the old site was a single word.

eg) the text references in the DB for the “OldSite” needs to be updated to “New Site”.

So the issue is that if i do a search replace, URL links become broken because there will be a space inserted into the url_title.

Considerations:
* Playa Fields
* URL links
* Case sensitive

I think that only the channel_data & channel_titles table’s will need updating.

Also thinking I could run some regex replace over the .sql, but I don’t know enough to know how to write the conditions…

Does anybody know how to write the required SQL statement????

Have a great day

Symon :O)

Found this on stack overflow if its much help to you…
http://stackoverflow.com/questions/506826/selecting-a-database-in-mysql-with-spaces-in-its-name

This is what i use for search and replace….
http://interconnectit.com/124/search-and-replace-for-wordpress-databases/

Thanks for the Reply Edd, I ended up using EE’s native search and replace tool, table by table, it did the trick 😊