note 61943 deleted from function.mysql-real-escape-string by betz

Note Submitter: datacruser88 at yahoo dot com ---- it's a shame that it doesn't escape all strings that can affect a search like '_' if you do a search say select * from userdb where email like 'david_%'; it will select all strings with 'david' at the beginning and ignore the underscore, but if you do select * from userdb where email like 'david\\_%' it's closer to what you are looking for and will find all email address that begin 'david_' I know this is true with mysql 4.0.1, not sure about other versions. There must be other characters like that. No?