SV: Matching escaped characters

2001-02-09 Thread Pål Wester
a [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\&

Re: Matching escaped characters

2001-02-09 Thread Anna
> 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 tr

Matching escaped characters

2001-02-08 Thread Greg Ederer
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