Mysql delete user id *help*

[Almax1]

In Mysql i want to delete user id's @ 0 and there posts but i am unsure how to run the query

user id's @ 0 (removed members) are still being called up from some hacks

help needed please anyone ?

[N9ne]

I don't understand what you mean, user ids at 0? Please could you explain some more...

[Almax1]

Originally Posted by N9ne

I don't understand what you mean, user ids at 0? Please could you explain some more...

In a recent board move some members were not transferred to the new place there user ids are now 0 i want to delete them from the mysql database as they are still being called up with some hacks installed

[N9ne]

Oh, so you want to remove all users who have userid = 0?

DELETE FROM user WHERE userid=0;

BACKUP YOUR DATABASE BEFORE DOING THIS. I won't be held responsible for things going wrong .

[Xenon]

there won't be a single user with userid 0.
you just can delete posts from guests:

[sql]DELETE FROM post WHERE userid = 0[/sql]