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

vindarel profile image

Common Lisp HTML templates: using Djula in .lisp files

vindarel -

florianlenz profile image

Serverless for greenfield projects: How data-driven architectures are revolutionizing your software development

Florian Lenz -

theguuholi profile image

How to Build an Effective Software Engineer CV

Elxpro -

ikoh_sylva profile image

Secure Remote Access to AWS Environments

Ikoh Sylva -