I am not a SQL pro and I deleted all the uses to a forum that I run.

I used the following SQL statement intending to delete user_id 7 and 12.

DELETE FROM `phpbb_users` WHERE `user_id` = '7' or '12'

Instead it deleted all the user_id's! What is wrong with my statement?

Bruce

We need to analyze your 'WHERE' clause peice by peice

what you're telling the database is this:

Look at each row in the tabe,
if user_id = 7 is true then delete it
or, if 12 is true then delete it.

since any non zero number will always evaluate to true, every row gets deleted.

You need to change your query to look like this :

DELETE FROM `phpbb_users` 
WHERE `user_id` = '7' 
   OR `user_id` = '12'

Thanks!