Re: escaping character in sql statements

From: Todd Farmer <todd(at)mysql.com>
Date: Thu Oct 25 2007 - 05:55:43 EDT

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=lists@pantek.com

Received on Thu Oct 25 05:56:03 2007