Drunken
June 17th, 2003, 06:19 AM
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 :(
any sugestion ?
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 :(
any sugestion ?