K
K
kaxa32012019-09-13 17:45:58
SQL
kaxa3201, 2019-09-13 17:45:58

Get values ​​with null field, how to do it?

There is a field `deleted_at` whose values ​​are on the screen 5d7bab4ab4abd120176613.png
how can I get records whose values ​​are empty null
I try like this

select * from "operators" where ("deleted_at" = 'NULL')

mistake
ERROR: invalid input syntax for type timestamp: "NULL"

Answer the question

In order to leave comments, you need to log in

2 answer(s)
L
Lazy @BojackHorseman, 2019-09-13
@kaxa3201

SELECT * FROM operators WHERE deleted_at IS NULL

N
Nujabes37, 2019-09-13
@Nujabes37

https://www.w3schools.com/sql/sql_null_values.asp

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question