Is ther a way with sql to delete tags with two letters like "is" "in"
Printable View
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?
Thanks for the code for the sql. Pretty helpful. I really have to organize such large databases.
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
will this patch work for vshare 2.8.1? or there would be another code? i tried to delete from my admin but there is only option to disable not to delete. can you add the option to delete in the admin as well? i am using vshare 2.8.1 please.
waiting for your help.
Kiran
Hi,
Open a support ticket at BuyScripts Helpdesk
with your vShare admin and FTP login details.
Thanks,
Buyscripts Team.