Validates_format_of :email in database

I was forgot To apply
validates_format_of :email,

validates_format_of :contact_personal_email

This makes a lots of invalid emails of users . Now i fixed it on model
But the invalid emails now exists in my database (mysql).
Now i have to manually change the all invalid emails . but for this i
required a Report of all user have invalid email. (something in
migrations or find_by_sql)
I do not how to start this.

Please suggest .