Given the Users table:
| ID |  NAME      | PASSWORD    | ADDBY  |
------------------------------------------
| EX | IRWANEX    | AB8934B495S |  NULL  |
Will the following query return only one record?
SELECT * FROM USERS WHERE ADDBY = NULL
Explanation
To make it work properly we should use =NULL comparison instead of IS NULL.

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback