List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 31 2000 9:19pm
Subject:Re: Multiple MySQL deletes
View as plain text  
In the last episode (Oct 31), rpruitt@stripped said:
> I'm trying to delete multiple email addresses from a database.
> I've tried this --
> 
> delete from table where email IN ('address1@stripped, address2@stripped');

you have only one value in your IN list.  You want:

delete from table where email IN ('address1@stripped', 'address2@stripped');

-- 
	Dan Nelson
	dnelson@stripped
Thread
Multiple MySQL deletesrpruitt31 Oct
  • Re: Multiple MySQL deletesDan Nelson31 Oct
  • Re: Multiple MySQL deletestest2 Nov
Re: Multiple MySQL deletesHank Leininger31 Oct
  • Re: Multiple MySQL deletesrpruitt31 Oct
    • Re: Multiple MySQL deletestest2 Nov