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

d_thiranjaya_6d3ec4552111 profile image

🚀 CI/CD Tips: Essential Tips and Tricks for Developers

Pawani Madushika -

jemmyasjd profile image

Git and Github

Jemmy Dalsaniya -

gilles_hamelink_ea9ff7d93 profile image

"Transforming Education: The Power of Social Determinants and AI Collaboration"

Gilles Hamelink -

vdaubry profile image

Déverrouiller l'Avenir du Travail : Comment les Modèles Hybrides Façonnent l'Engagement des Employés en 2023

vdaubry -