Topic: Help with deleting multiple users

Hello

I want to delete all users with zero posts, except those with email addresses ending in co.nz

I believe that the user management extension is not ready for 1.3 yet.

Can I do this with phpmyadmin directly? Will this adversely affect the operation of 1.3? And lastly, how would the query be phrased?

Thanks.

2 (edited by User33 2009-01-05 22:59)

Re: Help with deleting multiple users

DELETE FROM users WHERE num_posts=0 AND email NOT LIKE '%.co.nz' AND id!=1

Remember to add your table prefix before 'users' on the query.

Re: Help with deleting multiple users

Garciat wrote:
DELETE FROM users WHERE num_posts=0 AND email NOT LIKE '%.co.nz' AND id!=1

Remember to add your table prefix before 'users' on the query.

                        Last edited by Garciat (Today 10:59:22)[url="garciat.org/">Garciat - Die hard

Some info about me

.. and if I use "select' instead of delete I can first see?
Thanks for the reply

Re: Help with deleting multiple users

Yeah, if you want to see which users should be deleted, use 'SELECT *' instead of 'DELETE'.