Today’s applicant identifies himself as please kill me, what hey, come on my friend. Things are not so bad. Also, you shouldn’t let the bad code you inherited make you depressed – it should make you revenge.
We’re sharing today’s simple representative line because it’s not just representative of our submitter’s codebase, but the one that appears surprisingly often.
SELECT * FROM users WHERE last_name='NULL'
Now, I don’t think this code affected Mr. Null, but it certainly could have. It’s just a special case when names are difficult.
In this application, last_name is a NULL field. They could only store a NULLbut due to data sanitization issues, they are stored 'NULL' instead of – string. NULL it is not 'NULL'and therefore – we have a lot 'NULL'from which it may have been intended NULL, but it can also be someone’s last name. We have no way of knowing at this point.
[Advertisement]
Otter – Secure your servers automatically without the need to log into the command line. Get started today!