I would like to get a unique based on email address (MySQL)
Are you saying just all the unique email addresses?  Have you tried incorporating DISTINCT in any way?

As for the others, seems like an WHERE statement would be the way to go.