I found a really helpful tip on Xaprb for comparing result sets in MySQL:

It’s a quick way to determine if you have two tables that are properly in sync. Although there are better ways to compare tables in replicated environments, this method can get it done pretty quickly.