Skip to content

Helpful MySQL Queries #149

@j0hannr

Description

@j0hannr

Helpful MySQL Queries

Delete Usermeta of delete Users

DELETE FROM YvvdnuETGP_usermeta WHERE user_id NOT IN (SELECT ID FROM YvvdnuETGP_users);

Delete Spam User

DELETE FROM YvvdnuETGP_users
WHERE display_name LIKE '%CLICK HERE%'
OR display_name LIKE '%д%'
OR display_name LIKE '%ш%'
OR display_name LIKE '%и%'
OR display_name LIKE '%П%'
OR display_name LIKE '%User%'
OR display_name LIKE '%EUR%'
OR display_name LIKE '%MILLONARIO%'
OR display_name LIKE '%CHF%'
OR display_name LIKE '%arrenberg.app%'
OR display_name LIKE '%yandex%'
OR display_name LIKE '%docs.google.com%'
LIMIT 10000

Metadata

Metadata

Assignees

Labels

documentationImprovements or additions to documentation

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions