WordPress.org

Ready to get started?Download WordPress

Forums

mysql QUERY to insert into 50k posts (1 post)

  1. Klark0
    Member
    Posted 3 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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.