How about
'Mel\\''nikova'
??
mvh:
Pål Wester, programmerer
never.no as, stortingsgt 30, 0161 Oslo
tlf: 22 01 66 20, fax: 22 01 66 21
direkte: 22 01 66 34, 906 900 62
http://never.no - icq:103476059
~ f u cn rd ts u prb a gk ~
> -----Opprinnelig melding-----
> Fra: Anna [mailto:[EMAIL PROTECTED]]
> Sendt: 9. februar 2001 21:45
> Til: [EMAIL PROTECTED]
> Emne: Re: Matching escaped characters
>
>
> > 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
---------------------------------------------------------------------
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
