What can I say? I debated for quite awhile, diddled around, cut and pasted, asked around, diddled some more, googled, and finally said, “self, you HAVE a book on mySQL. Use it.”
Duh.
And there, on page 154, was what I sought.
I tried it in a “cautious” mode and then let rip with this result:
” Affected rows: 1180 (Query took 0.0695 sec)”
Yeah baby, now that’s what I’m talking about. So the blogger-import-title problem – a thing of the past. And while I was messing around directly on the mySQL side of things, I think I got rid of all the duplicate posts. Since I won’t be importing anymore from the blogger side, dupes won’t be a problem.
So yeah for me – if only there was a merit badge or something.
For posterity, if you’re trying to replace ugly titles in WP caused by importing from blogger, and can work with phpMyAdmin to access the mySQL, consider this:
`UPDATE wp_posts
SET post_title = ‘—-‘
WHERE post_title >= 30
AND post_title <= 99999999999999999`
Remove the single ticks at the beginning and end. Back up FIRST! Yes – BACK UP!
