Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
# # 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' )
|setup wamp server for first time||2||83|
|Count rows in a MySQL statement, but don't return the value in the results||4||40|
|how to access a remote mysql database with xampp||3||24|
|Could you point what is needed to make an array to be inserted as MySQL table's lines by using PHP?||25||66|