sql - Delete many Wordpress users thru mysql -

sql - Delete many Wordpress users thru mysql -

i downloaded , manually filtered users database mysql, , have users don't want delete. how should create query?

i have 100 users , want maintain user id:1, 2, 6, 8, 19, 22, 30 , delete rest.

thanks in advance.

as tagged wordpress, assume you're using wordpress.

hence, here's solution you're looking for

$users = get_users(); $preserve_users = array(1,2,6,8,19,22,30); // ids of users want preserve. foreach($users $user){ if ( !in_array( $user->id, $preserve_users ) ) { wp_delete_user( $user->id ); // delete user if not in preserve user list } } reference:

http://codex.wordpress.org/function_reference/wp_delete_user

mysql sql wordpress