# Sql

**URL:** <https://forum.kirupa.com/t/sql/23381>\
**Category:** programming\
**Created:** [June 17, 2003, 9:19am UTC](https://forum.kirupa.com/t/sql/23381 "2003-06-17T09:19:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Drunken](https://avatars.discourse-cdn.com/v4/letter/d/a4c791/32.png) [@Drunken](https://forum.kirupa.com/u/Drunken)\
**Post date:** [June 17, 2003, 9:19am UTC](https://forum.kirupa.com/t/sql/23381/1 "2003-06-17T09:19:00Z")

</div>

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

```php
 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:

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

```

but didn’t work too ☹

any sugestion ?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [June 17, 2003, 10:31am UTC](https://forum.kirupa.com/t/sql/23381/2 "2003-06-17T10:31:17Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [June 19, 2003, 5:20am UTC](https://forum.kirupa.com/t/sql/23381/3 "2003-06-19T05:20:36Z")

</div>

lol dont ya hate that