Database queries | Community Development | Sandbox ConnAct

1. Sorry, I should be more clear. It's a bit technical and we typically don't offer this for clients because it doesn't catch every single url. When we have done this in the past, clients will find urls in other places that were missed.
   1. We have a table in the database Dyve_Content that stores some content types, we can do a find and replace on the ContentBody field for the below content types. 
      1. Content types the Find and Replace will affect
         1. Articles
         2. Blogs
         3. CMS Pages
         4. Discussions
         5. Wiki
   2. Page Builder content is stored in another table, we will perform a find and replace on your Page Builder page content as well.
   3. There are other areas our find and replace won't update such as wall posts, content comments, chat messages and more. Since this isn't a standard service that isn't used often and our database changes constantly, we do not have documentation for this process. 
   4. We will perform a one-time find and replace for the content types listed above and Page Builder pages(Excludes hard coded urls in templates).
   5. If content is copied from Transportlab to the new community after the clone is done, we will not perform a find and replace on the new content.

ref 1.1.1  Events are in a different table called Dyve_Events, I can run a find and replace on this table as well.  Ideas are in a different table called Dyve_Ideas, I can run a find and replace on this table as well. Videos will auto transfer since you cant specify a link besides Youtube and Vimeo. Photos do not contain links since you can't use the editor in the description. I'll update the following tables: