• From: New Zealand
  • Registered: 2006-12-14
  • Posts: 30

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.

asardar's Website

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

  • User33
  • PunBB senior member
  • Offline
  • Registered: 2008-02-03
  • Posts: 875

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.

  • From: New Zealand
  • Registered: 2006-12-14
  • Posts: 30

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

asardar's Website

  • User33
  • PunBB senior member
  • Offline
  • Registered: 2008-02-03
  • Posts: 875

Re: Help with deleting multiple users

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