Skip to content
Advertisement

Unable to query null in datetime column in mysql

select query

There are are many entries having NUll as ShippedDate, one of them can be seen in the photo, but when i search for those entries where ShippedDate is NULL is get a empty set.

How do i select all having NULL as ShippedDate

Advertisement

Answer

You use wrong operator, equal not work with null

... WHERE ShippedDate is NULL
User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement