Support » Fixing WordPress » blogger to wordpress: replacing the "page break" html tag

  • Resolved Waqas


    hi I recently transferred my blogger blog to wordpress. everything is working fine except one thing.

    All of my blogger posts have <a name="more"></a> as a full post jump where as wordpress uses <!--more-->

    Thats why my index pages are showing full posts. they are so lengthy and look totally disaster. what do I do ? 🙁

    can I replace <a name="more"></a> with <!--more--> using sql query?

    if its possible then please tell me the query. Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Waqas


    ok, I’ve solved it myself by just studying a little bit about sql 😀

    just run it in sql

    UPDATE wp_posts SET post_content = REPLACE(post_content, '<a name="more"></a>', '<!--more-->')

    if you using wp_prefix don’t forget to add that to wp_[you prefix here]posts


    wp rox – cheers

    I was having a similar problem for my site that I imported from blogger and I did not know SQL.

    So I installed this plugin search and replace which did the SQL replace part for you. Plugin Link below:

    In the “Search for:” section put

    In the “Replaced with” section put <!–more–>

    Click Go and you are done.

    Once you install the plugin, you can access the plugin interface directly from the plugins install page of wordpress. It doesnt create a new tab in settings or anything.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘blogger to wordpress: replacing the "page break" html tag’ is closed to new replies.