Re: escaping character in sql statements

--------------070206080506060609010209
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Mark,

If you are trying to find the row as listed below, you still have too 
many backslashes.

To find: '\\192.168.0.100\clients\\o'rielly\file1.pdf'

Look for: '\\\\192.168.0.100\\clients\\\\o\'rielly\file1.pdf'
OR: "\\\\192.168.0.100\\clients\\\\o'rielly\file1.pdf"

This assumes you are testing the query using the mysql console or query 
analyzer.

Now, it could be more complicated than that if you are writing the query 
in a Perl or other language script. If you are doing this with a script, 
I would suggest that after creating the sql statement, print it to your 
page so you can see exactly what you are sending to mysql. Copy the 
generated statement and paste it into your query analyzer to see your 
result set. Then keep playing with it until you get what you want.

Randy Clamons
Systems Programming
[email protected]



Mark Mchugh wrote:
> hi,
> i need double the number of them cos in the database the file/path name is stored as
>
> \\192.168.0.100\clients\\o''orielly\file1.pdf
>
> wierd?
>
>
> ----- Original Message ----
> From: Todd Farmer <[email protected]>
> To: Mark Mchugh <[email protected]>
> Cc: Petr Vileta <[email protected]>; mysql list <[email protected]>
> Sent: Thursday, October 25, 2007 10:55:43 AM
> Subject: 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?
>
>
>   

--------------070206080506060609010209--