 | | | Subject: Re: escaping character in sql statements | Subject: Re: escaping character in sql statements 2007-10-25 - By Todd Farmer
Back
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/win32?unsub=mysql@(protected)
|
|
|