Delete email from database

Question

I've got to delete about 10 email addresses from a huge database, wanted to find out the correct way to delete multiple emails from the db at once. I can delete one by one, just wondered if it was separating them by commas which I now need.

I presumed this is the appropriate SQL Statement:

DELETE FROM `subscribers` 
WHERE email='example1@example.com,example2@example.com,example3@example.com'

Is this the correct way to list multiple emails in order for them to be deleted from the database?

score 4 · Accepted Answer · answered Feb 26 '14 at 01:28

4

Use IN() and put the emails in quotes

DELETE FROM `subscribers` 
WHERE email IN('example1@example.com','example2@example.com','example3@example.com')

answered Feb 26 '14 at 01:28

juergen d

201,996
37
293
362

Fantastic, thank you. Will accept the answer later as I cannot for 15 minutes. – wharfdale Feb 26 '14 at 01:31
Append a `LIMIT 3` to be totally awesome. :) – CodeAngry Feb 26 '14 at 01:40
@CodeAngry: That does not improve anything. – juergen d Feb 26 '14 at 09:00
@juergend http://stackoverflow.com/questions/455476/does-adding-limit-1-to-mysql-queries-make-them-faster-when-you-know-there-will – CodeAngry Feb 26 '14 at 16:06
@CodeAngry: That may work for selects. Has to be tested for deletes and how do you know there are no duplicate emails? Then adding a limit will not delete all. – juergen d Feb 26 '14 at 21:14
@juergend There shouldn't be in the `subscribers` table. ;) – CodeAngry Feb 26 '14 at 22:38

score 2 · Answer 2 · answered Feb 26 '14 at 01:29

2

Instead of =, use IN. E.g.

DELETE FROM subscribers 

WHERE email IN ('example1@example.com','example2@example.com','example3@example.com')

answered Feb 26 '14 at 01:29

faintsignal

1,828
3
22
30

Delete email from database

2 Answers2