> 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
>
>
Are you sure it's stored with the slash? If you use a command like
addslashes(), the slash doesn't actually make it into the database.
You would have to add Mel\\\'nikova to get Mel\'nikova into the database.
Anna
---------------------------------------------------------------------
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
