I've looked high and low for a solution that works for me and I've had little luck yet.
Basically, I have a tables with email addresses in.
Table 1 has an 'Active' field which is either 0 or 1.
Table 2 simply has 1 field which is an email address.
If the email address is in table 2, I want to set Active in table 1 to 0.
So far, I've written a quick PHP loop which runs through one table and updates another in the process.
I have 150,000 email addresses to run through - this isn't working well...
Does anyone have any recommendations for a speedy solution to the problem?
Apologies if something similar has been answered before...