How to check mysql if a string matched with parts from database? : i want to do a kind of blacklist so i store in my database

    id|value
    -----------
    1|test.com
    2|example@
    3|@another.
    ...

Now i looking for the fastes way to check if a given string (a emailadress for example) matched with a part of the values from the db.

For exmple
my@mail.com -> no result in db -> no spam
example@mail.com -> matched with ID2 -> spam
...

Is there a way to do it insider the mysql statement?

For the moment i see only the way to load all values in a array an check this, but this way takes a lot of resourses and its really slow.

Thanks a lot.