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='[email protected],[email protected],[email protected]'

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('[email protected]','[email protected]','[email protected]')

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 ('[email protected]','[email protected]','[email protected]')

answered Feb 26 '14 at 01:29

faintsignal

1,828
3
22
30

Delete email from database

2 Answers2