Search code examples
mysqlsqlselectsql-like

How do I do a LIKE search with an @ in the search in MySQL?

I don't see @ as a special character in the MySQL list but my SELECT with a LIKE and an @ gives me an empty result. I would like to do something like

SELECT email from myTable WHERE email LIKE '%@domain.com'
Solution

  • You could try to use ESCAPE clause (wild guess):

    SELECT email 
from myTable 
WHERE email LIKE '%[email protected]' ESCAPE '!';

    Another option is to trim your email (probably some white characters):

    SELECT email 
from myTable 
WHERE TRIM(email) LIKE '%@domain.com';