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

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


No tags yet.