I have a data item (stored as a varchar) that looks like this:
Mel\'nikova
fieldname='Mel\'nikova' doesn't match it. Neither does
fieldname='Mel\\\'nikova'. fieldname='Mel%nikova' does produce a match,
and so does fieldname='Mel__nikova' (which leads me to believe that
mysql treats \' as two characters, rather than as an escaped character).
Is there some way to match this string without resorting to wild cards?
Thanks
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
