I been really busy learning new things, working and tweaking a lot of my wordpress site lately, theres a few good trick in mysql tricks that I find really useful. One such command is Replace. This is very useful when you need to make updates to a series of posts. For example your would like to change your links to nofollow.
update wp_posts set `post_content` = replace(post_content, ‘<a href=’, ‘<a rel=”nofollow” href=’)
How to sell incontent links
You can also sell in content links using this method.
Find the relevant anchor text.
Select post_name, post_title, guid, from wp_posts where post_content like ‘%make money from blogging%’;
This will give you the all the post that has this keyword
next add hyperlink by
update wp_posts set `post_content` = replace(post_content, ‘make money from blogging’, ‘<a rel=”nofollow” href=”http://www.wizcodeolution.com” >make money from blogging</a>’)
Another useful trick for SEO s to change the url from www.wizcodersolution.com/2008/09/post_title to www.wizcodersolution.com/post_title. I find that using wordpress dashboard do not change links for past post. You can use this command to up date the URLs
update `wp_posts` set `guid` = concat( ‘http://www.qshape.com’, `post_name` )
