 | | | Subject: Re: escaping character in sql statements | Subject: Re: escaping character in sql statements 2007-10-25 - By Randy Clamons
Back
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
randy@(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 <todd@(protected)>
> To: Mark Mchugh <mark_mch@(protected)>
> Cc: Petr Vileta <petr@(protected)>; mysql list <win32@(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?
>
>
>
|
|
|