ashes999

Thanks, that’s positively brilliant ??

Yep. Not bad for dynamic search/replace, but not what I want.

Yes, I’m looking for a one-shot change. Is there a simple way to do it? If not, I can probably figure out an SQL statement that’ll cover the changes for me.

Something like:

UPDATE wp_posts SET post_content <something> WHERE post_content LIKE (SELECT post_content FROM wp_posts WHERE post_content LIKE <search string>)

You guys are awesome. Thanks very much!

My hosting is on a Linux server.

Wow. I’m impressed. THAT is quite amazing. Thanks!

The plugin worked–thanks, Kafkaesqui! EXACTLY what I needed!

Sorry, I’ll clarify.

I need to modify the Search field on my blog so that it searches not only article content, but also article excerpts.

The reason? Sometimes I reference things in my article, but don’t put the full name, except in the excerpt; so the excerpt contains content that lets you identify something from out-of-context, which is useful sometimes.

This is because I use different words in the excerpt and the article (slightly, but they have major ramifications to searchability).

Thanks, that’s exactly it: relative URLs.

Nevermind, got it. You can get the necessary info from various functions like single_post_description and things like that. Just need to modify your header.php and check if you’re in a post, i.e. not in home or in the archives or something.

Brilliant, thanks!

No, I’m trying to add all posts to a new category. But thanks, will try a modification on that.

Hmmmmm. I might do it manually, since it’ll only take ~10 minutes or less (if I do it today). Might be able to trick it with an SQL statement…

My bad. The answer is in this thread: you need a wordpress.com account for an API key.

I experience problem. The key turned up fine on my old (dead) wordpress.com account when I updated my account details. Doesn’t work with wordpress 2.0, it seems.