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?