Offers Need script or SQL to add tags to WP posts based on keywords found in content

[sitemaker]

I need the SQL (or a script) that would go through all the posts in a WP database, and add tags based on words in the post.

For example, if I have 11,000 recipes posted, well categorized but with no tags, and I want to add tags based on ingredients.

So I'd scan for posts containing "cardomom" and add that tag. Then scan for "rosewater" and add that tag. Then "honey" etc.

What would really be great is if the script would accept a whole bunch of keywords and do them all, so I wouldn't have to run it over and over for every ingredient that I can think of.

Or perhaps scan and build a complete keywords list; from which I'd selct which to make tags for.

Is there anything like that?

Thanks.

 

[breez]

This plugin may do the job, makes tag suggestions from Yahoo api
http://wordpress.org/extend/plugins/simple-tags/