WordPress.org

Ready to get started?Download WordPress

Forums

Replace all occurence of text (2 posts)

  1. DanLai
    Member
    Posted 8 years ago #

    Hello,

    I have migrated to WordPress, but I found that there are strange HTML special characters generated during the RSS Import process.

    How could I replace those characters?

    An example of the problem is here:
    http://danlai.talkmusic.org/?p=9

    Where you can see something like these:
    ""#000000""
    "%22http://www.blogthings.com/idealcareerquiz/%22"

  2. tomhanna
    Member
    Posted 8 years ago #

    You can use phpMyAdmin to do a search and replace in the database directly.

    Run this sequel query where xyz is what you want to replace and abc is what you want to replace it with.

    UPDATE wp_posts SET post_content=REPLACE(post_content, 'xyz', 'abc');

    http://wordpress.org/support/topic/42006

    If the odd characters are in a table other than post_content, of course, you'd have to use the appropriate table.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags