[UPHPU] Re: Deduping a list

[D. Turnbull]

If both your lists are (or can be) in a database, then I suggest running a
query something like this:

SELECT DISTINCT email_address
FROM good_email_table
WHERE email_address NOT IN (
    SELECT DISTINCT email_address
    FROM do_not_email_table)

If you can, let your DBMS do the work - it'll almost always be faster than
doing it w/ PHP.

Dave

>
> From: Ash <ashovi at qwest.net>
> Subject: [UPHPU] Deduping a list
>
> I have a list of email addresses and a list of those who have
> unsubscribed. (We get a new list to send to every time from our partner,
> but we have to keep track of those who have unsubscribed from getting
> our emails, and remove them from the new list every time.)
>
> So I have list 1 that has 10,000 email addresses in it and a list of
> unsubscribes that has about 200 email addresses. I want to remove all
> unsubscribes from the main list. Is there an easy way to do it?
>
> Ash
>
>
>
>