Re: escaping character in sql statements

for some reason this does not seem to work either?

• Original Message ---- From: Petr Vileta <petr@practisoft.cz> To: mysql list <win32@lists.mysql.com> Sent: Thursday, October 25, 2007 1:04:10 AM Subject: Re: escaping character in sql statements

Mark Mchugh wrote:
> Hi,
> I am writing an sql to retrieve data relating to certain files in a
> folder from my database. Some times part of the data may contain a '
> character.
>
> here's an example of the sql
>
> select * from files where location =
> '\\\\\\\\192.168.0.100\\\\clients\\\\o''orielly\\\\file%'
>
>

This should be

select * from files where location =
'\\\\\\\\192.168.0.100\\\\clients\\\\o\'orielly\\\\file%'

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your  mail
from another non-spammer site please.)

-- 
MySQL Windows Mailing List
For list archives: 
http://lists.mysql.com/win32
To unsubscribe:  
  
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com





__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL Windows Mailing List
For list archives: 
http://lists.mysql.com/win32
To unsubscribe:    
http://lists.mysql.com/win32?unsub=lists@pantek.com