Yet another question about tags ,MySQL and deleting
-
Good day ladies and gentlemen.
After hours of research I found what I’ve been looking for all along. A query to delete tags that contain certain number of posts.
The query was written by moderator Mark / t31os .
Here it is bellow:DELETE a,c FROM database.prefix_terms AS a LEFT JOIN database.prefix_term_taxonomy AS c ON a.term_id = c.term_id LEFT JOIN database.prefix_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id WHERE ( c.taxonomy = 'post_tag' AND c.count = 0 )
What I am trying to do is set the range ,say for example from 1 to 230 c.count 1-230
Problem is I don’t know if it’s possible and I can’t seem to find anything related to ranges in this meaning…
Perhaps someone or maybe Mark could help?Thank you
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Yet another question about tags ,MySQL and deleting’ is closed to new replies.