So usually I would just do a database search and replace for changing my URL but what I've done now is decided to split my site into two different sites which works great for me because of the way I organized content with pages and posts.
All the pages have links going to posts on the same site. I'm moving all the posts to it's own site on domain #2 and I want those links from the pages on domain #1 to point to domain #2. I don't see any problem doing this except for being able to target only pages and not posts. I'm not sure how to do that since wp_posts contains both pages and posts. If anyone has suggestions those are welcome and solutions are very much appreciated.
Here is what I usually use to change the URLS throughout my content:
update wp_posts set post_content = replace( post_content, 'old_domain.com', 'new_domain.com');