Is ther a way with sql to delete tags with two letters like "is" "in"
Is ther a way with sql to delete tags with two letters like "is" "in"
Hi
The following sql can delete tags with 2 letters.
Try it now.Code:DELETE `t`, `tv` FROM `tags` AS `t` ,`tag_video` AS `tv` WHERE LENGTH( t.tag ) <=2 AND t.id = tv.tag_id;
Your Friendly
Buyscripts Team
Also tags are at table videos-> videos_keywords
How to delete from there?
Last edited by alotp; 11-25-2010 at 12:09 AM.
Thanks for the code for the sql. Pretty helpful. I really have to organize such large databases.
Only vshare sites allowed in signature
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
thank you
Also a good plugin for vshare will be to delete the Noise Tags.
PHP Code:
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
Bookmarks