DEV Community

AquaCat
AquaCat

Posted on

【MySQL】When using "NULL" in WHERE CLAUSE

#mysql

Do not write

SELECT * FROM [table_name] WHERE [column_name]=NULL;
Enter fullscreen mode Exit fullscreen mode

Use "IS" for NULL!!!!

SELECT * FROM [table_name] WHERE [column_name] IS NULL;
Enter fullscreen mode Exit fullscreen mode

I wasted 2hours for this...

Top comments (0)

Read next

akhil_mittal profile image

Streamlining Banking Application Deployments with DevOps, Cloud Automation, and Modern Data Strategies

akhil mittal -

yasmine_ddec94f4d4 profile image

Understanding the CAP Theorem in Distributed Systems

Yasmine Cherif -

sarahthomasdev profile image

Which iOS Performance Testing Tools should be used in 2025?

Sarah Thomas -

vania_gomes profile image

Entendendo props e useState no React: Como Passar e Gerenciar Dados Entre Componentes

Vânia Gomes -