Re: escaping character in sql statements

Mark Mchugh wrote:
> for some reason this does not seem to work either?

I think Petr's comment is correct, but perhaps there are other reasons 
this is not working the way you expect.  It seems like you have double 
the number of backslashes you need:

mysql> select '\\\\\\\\192.168.0.100\\\\clients\\\\o''orielly\\\\file%';
+----------------------------------------------+
| \\\\192.168.0.100\\clients\\o'orielly\\file% |
+----------------------------------------------+
| \\\\192.168.0.100\\clients\\o'orielly\\file% |
+----------------------------------------------+
1 row in set (0.00 sec)

You might try this format instead:

mysql> select '\\\\192.168.0.100\\clients\\o''orielly\\file%';
+-----------------------------------------+
| \\192.168.0.100\clients\o'orielly\file% |
+-----------------------------------------+
| \\192.168.0.100\clients\o'orielly\file% |
+-----------------------------------------+
1 row in set (0.00 sec)

Is that more like what you are hoping to match?


-- 
Todd Farmer


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]