WordPress.org

1. cpatience
   Member
   Posted 4 months ago #

   I just did a Blogger to WordPress import and for some reason, there is a ">" at the beginning of every single Post title and post content.

   Is there a database query I can run to remove the ">" at the beginning of post titles?

2. cpatience
   Member
   Posted 4 months ago #

   Just in case anyone needs the answer, access your database via phpMyAdmin and use:

   UPDATE wp_posts
   SET post_title =
   TRIM(LEADING '>' FROM post_title);

3. cpatience
   Member
   Posted 4 months ago #

   make sure you add backticks around wp_posts and post_title

Reply

You must log in to post.