Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
# # In both cases below consider all instances of "a@b" to also sometimes be of the form "a" # # # Case 1: Does not return row in case of "a@b", does work in case of "a" # SELECT `pwd` FROM `accts` WHERE IF ( INSTR('@', 'a@b') != 0, `user` = 'a@b' AND `realm` IS NULL, CONCAT_WS('@', `user`, `realm`) = 'a@b' ) # # Case 2: Gives undefined column error # SELECT `pwd`, CONCAT_WS('@', `user`, `realm`) AS email FROM `accts` WHERE IF ( INSTR('@', 'a@b') != 0, `user` = 'a@b' AND `realm` IS NULL, `email` = 'a@b' )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.