Re: (SQL Question) WHERE NOT IN A LIST

2003-07-18 Thread Paul DuBois
At 12:29 -0500 7/18/03, Tom O'Neill (MySQL User) wrote: Hi, Is there a way I can run a query that will delete all items that are not in a list? For example I have a bunch of records in a table and I want to remove all of them that are not in a comma delimited list that I have recieved from anothe

(SQL Question) WHERE NOT IN A LIST

2003-07-18 Thread Tom O'Neill \(MySQL User\)
Hi, Is there a way I can run a query that will delete all items that are not in a list? For example I have a bunch of records in a table and I want to remove all of them that are not in a comma delimited list that I have recieved from another application. I was thinking that I could create a que