Re: my sql pattern search and support for backslash??

[VVM Ravikumar Sarma Chengalvala]

Hi,
I donot even get that with an additional backslash
also.In my case it just ignores the backslash and goes
ahead with the search .
Regards,
Ravi
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On
Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM
> Ravikumar Sarma Chengalvala wrote:
> >
> > Even after escaping mysql just seems to be
> ignoring it.
> 
> Odd. I'm seeing something other than what I first
> expected. Watch
> this...
> 
> ---snip---
> 
> mysql> CREATE TABLE slash_test ( foo VARCHAR(30) );
> Query OK, 0 rows affected (0.02 sec)
> 
> mysql> INSERT INTO slash_test VALUES ('blah\\blah');
> Query OK, 1 row affected (0.01 sec)
> 
> mysql> SELECT * FROM slash_test;
> +-----------+
> | foo       |
> +-----------+
> | blah\blah |
> +-----------+
> 1 row in set (0.01 sec)
> 
> mysql> SELECT * FROM slash_test where foo like
> "blah\\%";
> Empty set (0.00 sec)
> 
> mysql> SELECT * FROM slash_test where foo like
> "blah\\\%";
> +-----------+
> | foo       |
> +-----------+
> | blah\blah |
> +-----------+
> 1 row in set (0.01 sec)
> 
> ---snip---
> 
> Hm. I needed one more '\' than I would have thought
> necessary.
> 
> Is that what you see as well?
> 
> Jeremy
> -- 
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878    Fax: (408) 349-5454    Cell:
> (408) 439-9951
> 
> MySQL 3.23.29: up 2 days, processed 15,793,960
> queries (79/sec. avg)


____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

---------------------------------------------------------------------
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