Support » Plugins » Hacks » mysql QUERY to insert into 50k posts

  • Some of 50,000 posts have the more tag. Some don’t.

    I want to automatically insert the more tag into the ones that don’t have it.

    I can Select the ones that do like this:

    SELECT * FROM wp_posts WHERE (
    post_content LIKE '%<!--more-->%'
    );

    but that’s about as far as i can get with my knowledge and Google.

    please help.

  • The topic ‘mysql QUERY to insert into 50k posts’ is closed to new replies.