[wp-hackers] Cleaning up tags

Michael E. Hancock justmichaelh at gmail.com
Fri Jan 8 14:06:30 UTC 2010

From: "Lari Elovainio" <lari at kairo.fi>
> What I don’t know, is how to delete the corresponding 8000 rows from the 
> wp_term_relationships table. I guess it requires some kind of join, but i’m 
> not that familiar with mysql. So I need to delete rows from 
> wp_term_relationships where 'term_taxonomy_id' is something that has 
> 'count' lower than 2 in wp_term_taxonomy. How do I do that? I’m sorry if 
> this is trivial but I haven’t been able to figure it out.

t31os_ has some code you might find useful



More information about the wp-hackers mailing list