Wrong Regular expressions, how to recover black listed

[AHK]

Hello,
i have added Regular expressions in settings/email-blacklist.
one of my Regular expressions was wrong which cause all emails end with @hotmail.com in black list.
now i have all emails ending with @hotmail.com from all customers as blacklisted.

I have removed the Regular expressions which was causing this issue but still emails are showing as black listed.
how can I restore all @hotmail.com emails back to normal which was blacklisted sue to this Regular expressions?

or any SQL query?

I don't want to make all emails @hotmail.com as normal, there is real blacklisted too but there is one who was black listed by this Regular expressions.

Thanks

 

[frm.mwz]

how can I restore all @hotmail.com emails back to normal which was blacklisted sue to this Regular expressions?

If you have that list of addresses that were effected by it, then you can run it against the whole blacklist.

 

[twisted1919]

You can also include the last_updated column in the query and only affect subscribers modified in the last x hours.