# Как вместе проверять 2 условия в WHERE?

**URL:** <https://forum.itvdn.com/t/kak-vmeste-proveryat-2-usloviya-v-where/2844>\
**Category:** SQL\
**Created:** [21.11.2018 13:21:35 UTC](https://forum.itvdn.com/t/kak-vmeste-proveryat-2-usloviya-v-where/2844 "2018-11-21T13:21:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![odekolon70](https://forum.itvdn.com/letter_avatar_proxy/v4/letter/o/e8c25b/32.png) [@odekolon70](https://forum.itvdn.com/u/odekolon70)\
**Post date:** [21.11.2018 13:21:35 UTC](https://forum.itvdn.com/t/kak-vmeste-proveryat-2-usloviya-v-where/2844/1 "2018-11-21T13:21:35Z")

</div>

```
SELECT *
FROM User
WHERE User.id IS NULL AND User.name = 'google'
```

Данный код возвращает всех User`ов у кого name = 'google'.

Но мне нужно проверять если id равно NULL и после этого проверять name равно ли 'google', тобишь 2 условия сразу

---

<div class="post-metadata">

**Author:** ![p3tr0ff.petor](https://forum.itvdn.com/letter_avatar_proxy/v4/letter/p/c67d28/32.png) [@p3tr0ff.petor](https://forum.itvdn.com/u/p3tr0ff.petor)\
**Post date:** [21.11.2018 14:02:44 UTC](https://forum.itvdn.com/t/kak-vmeste-proveryat-2-usloviya-v-where/2844/2 "2018-11-21T14:02:44Z")

</div>

```
SELECT * FROM (
SELECT * FROM User
WHERE id IS NULL) t2
WHERE t2.name = 'google'
```

---

<div class="post-metadata">

**Author:** ![p3tr0ff.petor](https://forum.itvdn.com/letter_avatar_proxy/v4/letter/p/c67d28/32.png) [@p3tr0ff.petor](https://forum.itvdn.com/u/p3tr0ff.petor)\
**Post date:** [21.11.2018 14:03:20 UTC](https://forum.itvdn.com/t/kak-vmeste-proveryat-2-usloviya-v-where/2844/3 "2018-11-21T14:03:20Z")

</div>

Ну или вот, как по мне - более адевратный вариант записи

```
SELECT *
FROM User
WHERE (User.id IS NULL) AND (User.name = 'google')
```

---

<div class="post-metadata">

**Author:** ![eugenesalnik](https://forum.itvdn.com/letter_avatar_proxy/v4/letter/e/c0e974/32.png) [@eugenesalnik](https://forum.itvdn.com/u/eugenesalnik)\
**Post date:** [21.11.2018 14:07:21 UTC](https://forum.itvdn.com/t/kak-vmeste-proveryat-2-usloviya-v-where/2844/4 "2018-11-21T14:07:21Z")

</div>

Подучите [SQL](https://itvdn.com/ru/video/sql-essential) , вам это будет полезно

---

<div class="post-metadata">

**Author:** ![antonmihailichuk](https://forum.itvdn.com/letter_avatar_proxy/v4/letter/a/e19b73/32.png) [@antonmihailichuk](https://forum.itvdn.com/u/antonmihailichuk)\
**Post date:** [21.11.2018 14:10:24 UTC](https://forum.itvdn.com/t/kak-vmeste-proveryat-2-usloviya-v-where/2844/5 "2018-11-21T14:10:24Z")

</div>

[https://itvdn.com/ru/video/sql-essential](https://itvdn.com/ru/video/sql-essential)