Sql

I have a problem with a query to bd. I want check if an e-mail is in database, doing this query:

 SELECT * FROM users WHERE user = 'email@mail.com' 

but it didn’t find anything, but if I insert an value like this “email” in email field, then that query works… I thing is because the ‘@’,
and I try to this:

 SELECT * FROM users WHERE user like 'email@mail.com' 

but didn’t work too :frowning:

any sugestion ?

hi sorry, I have a mistake…the field isn’t user but mail…
now works of course :stuck_out_tongue:

lol dont ya hate that