Anyone know how to delete all inactif account with 0 post, in MySQL ?
Jul 31 2010, 03:19 in Support
Comments
linux4indians

dont know but would like to know for sure...

Jul 31 2010, 03:20
dedikinet

@Yann192 @linux4indians
#delete_inactive_user_with_sql you can use a this query on phpmyadmin


DELETE FROM `users` WHERE `num_posts` =0

Jul 31 2010, 06:40
vassko

thanks, this is useful

Jul 31 2010, 09:01
linux4indians

yeah it is...

Jul 31 2010, 09:02
zaghy2zy

but what if the user is just new? how could you nuke a user who just registered?

Jul 31 2010, 20:31
dedikinet

quick solution you can added registration date in the where filter ;)

Jul 31 2010, 21:22
Sharetronix · Contacts
Powered by Blogtronix