in phpmyadmin, I want to find all sites (in my multisite) which have a siteurl like http://xxxxxxx.example.com
xxxxxxx could be everything
= I want to find all the subdomain of example.com
In php my admin, i want to remove all tables of all sites which are subdomains of example.com
so all sites which have an URL like that : http://xxxxxxx.example.com
you can use these queries in your phpmyadmin
follow these steps before run these queries
1. take *backup of your tables first before run these queries
2. replace " PREFIX_ " with your wp prifix
Select * FROM PREFIX_blogs WHERE domain LIKE '%example.com%';
DELETE FROM `PREFIX_blogs` WHERE domain LIKE '%example.com%'
first The table wp_blogs is the one.
You can do the SQL with %example.com%
Ok but i have many many sites... so I need a request to display only the sites I want and a second request to remove all tables of this sites
with %example.com% I display the subdomains of example.com but I display too the sites which have example.com in its content.
I want just the subdomains.
Well if you do the search just in wp_blogs folder and only search on the field 'domain'. That solves the first problem.
i need a request