Email search without domain

0

I am doing a query to receive various data from DB, which involves entering the email field, but I do not want to do searches that show emails because of the domain.

For example, I have an email " [email protected] "

With the following query:

SELECT bb.email FROM bd_email bb WHERE bb.email like '%text_in_search%'

In the field you will receive from $ _GET [PHP], I can search for:

- "@abcde"
- "@abcde."
- "cde"
- "e.c"
- ".com"

Logically, I want to remove this type of query result so that it does not display data improperly.

  • But if you search the complete email, yes, it returns a result.

Do you know how I can form this query?

    
asked by anonymous 07.08.2017 / 13:52

0 answers