I used to use the following sql command to take all the words beyond “release. ” and before the words “Has graduated” and put them in the title.
I would normally end up with something like “Marine Corps Private June J. Jett”
UPDATE wp_posts SET post_title=(SELECT substr(post_content, LOCATE('ase.\n',post_content)+7,LOCATE('has Graduated',post_content)-LOCATE('ase.\n',post_content)-8)) where post_content like '%has graduated%' and post_title like '%hometown%';
However, since upgrading to 2.7, I now get “-Mime Type of File is image/jpeg –><div class=”po” It’s like it’s not finding the word release.
But why would it start at the version change?
- The topic ‘sql script not working’ is closed to new replies.