Delete all tags where tags_count = n

skypeleft

Active member

Aug 10, 2019

401

71

28

• Jul 26, 2022

• #1

Hi guys, I want to delete all tags where count = 1, because my database much more tags record in my database, phpadmin
Can you give me a SQL query to do that?. I don't see a tag table... my WordPress website
Thanks.

 

xsz

Well-known member

Trusted Uploader

Jan 12, 2020

253

260

63

An 👽 told me i live on the 🌑

• Jul 26, 2022

• #2

Here: https://gprivate.com/603vj

 

skypeleft

Active member

Aug 10, 2019

401

71

28

• Jul 26, 2022

• #3

xsz said:

Here: https://gprivate.com/603vj

Click to expand...

dont waste my times

 

xsz

Well-known member

Trusted Uploader

Jan 12, 2020

253

260

63

An 👽 told me i live on the 🌑

• Jul 26, 2022

• #4

skypeleft said:

dont waste my times

Click to expand...

You are literally being spoonfed information and you still complain about it?

 

Z

zzn

Member

Banned User

Jul 27, 2022

89

8

8

• Jul 28, 2022

• #5

I strongly recommend you don't try to approach this the way you are thinking. Terms and taxonomy in WordPress could be relatively complex and you could end up creating a bunch of issues for yourself by directly trying to use SQL for this.

 

Z

zzn

Member

Banned User

Jul 27, 2022

89

8

8

• Jul 28, 2022

• #6

Direct SQL queries are notorious for leaving behind orphaned artifacts when used for stuff like this.

 

Z

zzn

Member

Banned User

Jul 27, 2022

89

8

8

• Jul 28, 2022

• #7

While I don't have a solution for you exactly, I suggest you look into WordPress hooks and filters (or those of WooCommerce if you're using it) for this purpose instead.

 

Z

zzn

Member

Banned User

Jul 27, 2022

89

8

8

• Jul 28, 2022

• #8

I have this exact issue in my to do list for one WordPress website.

 

Z

zzn

Member

Banned User

Jul 27, 2022

89

8

8

• Jul 28, 2022

• #9

zzn said:

I have this exact issue in my to do list for one WordPress website.

Click to expand...

When I get to it and fix the problem, I will share the solution here for you and anyone else who is interested. But this might take a while.

 

lonewolf000

New member

Jul 20, 2022

21

4

3

• Jul 28, 2022

• #10

SQL HAVING Clause

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com