delete tags with 2 letters

[alotp]

Is ther a way with sql to delete tags with two letters like "is" "in"

[vshare2]

Hi

The following sql can delete tags with 2 letters.

DELETE `t`, `tv` FROM `tags` AS `t` ,`tag_video` AS `tv` WHERE LENGTH( t.tag ) <=2 AND t.id = tv.tag_id;

Try it now.

Your Friendly
Buyscripts Team

[alotp]

Also tags are at table videos-> videos_keywords
How to delete from there?

[mattfelton]

Thanks for the code for the sql. Pretty helpful. I really have to organize such large databases.

[vshare2]

Hi,

To remove tags with two letters from 'videos' table, do the following.

Download the attached zip file, extract and upload file to your vshare(public_html) folder.

Run uploaded file by web browser (YOUR_SITE.COM/delete_tags.php).

Thanks,
Buyscripts Team

[alotp]

thank you

Also a good plugin for vshare will be to delete the Noise Tags.

about|after|a|all|also|an|and|another|any|are|as|at|be|because|been|before|being|between|both|but|by|came|can|come|could|did|do|each|even|for|from|further|furthermore|get|got|had|has|have|he|her|here|hi|him|himself|how|however|i|if|in|indeed|into|is|it|its|just|like|made|many|may|me|might|more|moreover|most|much|must|my|never|not|now|of|on|only|or|other|our|out|over|put|said|same|see|she|should|since|some|still|such|take|than|that|the|their|them|then|there|therefore|these|they|this|those|through|thus|to|too|under|up|very|was|way|we|well|were|what|when|where|which|while|who|will|why|with|would|you|your