> 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

Reply via email to