I need to do a mass post edit on my wordpress I want to search all posts and remove something If the beginning of the wordpress post is <!--nextpage--> I want to remove the <!--nextpage--> What i mean is, if there is no text before <!--nextpage--> this is the first text that is in the post, then it must be deleted. Some of my posts are like this <!--nextpage--> blah blah <!--nextpage--> woawo <!--nextpage--> aadada So I want to remove ONLY ONLY the first <!--nextpage-->, NOT the other 2. There might be a space or something before the first <!--nextpage-->, or a line space, so you must take that into consideration. how to do this, probably done with a sql query? PM me if you can do it and give me your MSN. i'll pay $8 for it
When LOCATE('<!--nextpage-->', TRIM(post_content)) = 1 that means your post_content begins with <!--nextpage--> SELECT * FROM wp_posts WHERE LOCATE('<!--nextpage-->', TRIM(post_content)) = 1 Check if the select above give you the right posts for update. If yes, we will think about the UPDATE statement