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

afrin_ashar profile image

All about React Query

Afrin Ashar -

pentest_testing_corp profile image

Preventing File Inclusion Vulnerabilities in Laravel Applications

Pentest Testing Corp -

armando284 profile image

Enhancing LRU Cache with Configurable Data Persistence

Armando -

valeriavg profile image

Day 22: How the Tables have turned 🏓

Valeria -