delete tags with 2 letters

Printable View

11-22-2010, 12:22 AM
alotp

delete tags with 2 letters

Is ther a way with sql to delete tags with two letters like "is" "in"
11-22-2010, 09:50 AM
vshare2

Hi

The following sql can delete tags with 2 letters.

Code:

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
11-23-2010, 09:17 AM
alotp

Also tags are at table videos-> videos_keywords
How to delete from there?
03-14-2011, 02:37 AM
mattfelton

Thanks for the code for the sql. Pretty helpful. I really have to organize such large databases.
03-14-2011, 05:19 AM
vshare2

1 Attachment(s)

Remove tags with two letters from 'videos' table

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
03-14-2011, 01:08 PM
alotp

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
09-17-2011, 07:56 PM
clonevideos

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
09-19-2011, 04:48 AM
vshare2

Hi,

Quote:

Originally Posted by clonevideos

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

Open a support ticket at BuyScripts Helpdesk

with your vShare admin and FTP login details.

Thanks,

Buyscripts Team.