Hi folks, I've completed a wordpress installation locally using XAMPP, with a view to uploading it live in a few days.
I've imported nearly 1000 posts from my old Blogger blog, and unfortunately both post titles and the first line of each posts have a leading ">" character (apparently its a recognised php error of some sort).
I'm halfway to a solution but I need help going the rest of the way. I solved the issue of leading ">"s in the posts by running an SQL query on the local "mywordpress" SQL database which was set up as follows:
update wp_posts set post_content = TRIM(LEADING '>' FROM post_content);
How can I modify that query to remove the ">" in the post titles? Can anyone advise - I don't want to have to manually edit nearly 1000 posts!
Can I also say how fantasically flexible and powerful WordPress is - Blogger is like finger-painting in comparison. The difference is staggering, and I'm still only beginning to get my head around it all.
Thanks for any help!