Helpful MySQL Queries

[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