mysql QUERY to insert into 50k posts

  • Klark0

    (@klark0)


    14 years ago

    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.