Remove first character of all post titles?

  • Resolved cpatience

    (@cpatience)


    13 years, 1 month 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?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter cpatience

    (@cpatience)

    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);

    Thread Starter cpatience

    (@cpatience)

    make sure you add backticks around wp_posts and post_title

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Remove first character of all post titles?’ is closed to new replies.