MySQL performance, character sets, and left joins
March 19th, 2009
So I thought I was losing my mind when a simple LEFT JOIN on a new table was taking forever to complete: SELECT email FROM a LEFT JOIN b ON b.email=a.email WHERE b.email is null That’s about the simplest LEFT JOIN you can write to get all rows in a that are not in b. [...]