Re: escaping character in sql statements
Mark Mchugh <[email protected]> Thu, 25 Oct 2007 10:38:29 -0700 (PDT)
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
sorry, thats a typo, its the more traditional spelling....=0A=0A=0A=0A-----= Original Message ----=0AFrom: Lawson Cronlund <[email protected]>=0ATo: Ma= rk Mchugh <[email protected]>; mysql list <[email protected]>=0ASent: = Thursday, October 25, 2007 4:36:53 PM=0ASubject: RE: escaping character in = sql statements=0A=0A=0AJust a na=EFve question. Was your query to find a c= lient of o'oreilly=0A (as=0Ashown) or o'reilly (a more traditional spelling= )?=0A=0ARegards,=0A=0A=0A=0ALawson [email protected]=0A+1(480)30= 8-0641 (voice)=0A+1(602)996-0376 (fax)=0A =0A=0A-----Original Message-----= =0AFrom: Mark Mchugh [mailto:[email protected]] =0ASent: Wednesday, Octobe= r 24, 2007 12:50 PM=0ATo: mysql list=0ASubject: escaping character in sql s= tatements=0A=0AHi,=0AI am writing an sql to retrieve data relating to certa= in files in a=0A folder=0Afrom my database. Some times part of the data may= contain a '=0A character.=0A=0Ahere's an example of the sql=0A=0Aselect * = from files where location =3D=0A'\\\\\\\\192.168.0.100\\\\clients\\\\o''ori= elly\\\\file%'=0A=0A=0Athis recults returns no records from my database, ev= en though there are=0Arecords there. the records are path + file names, tha= ts why i have to=0A use=0Athe \ charater to escape them, this does not seem= to like me using ' to=0Aescape the ' character, any ideas?=0A=0A=0A=0A____= ______________________________________________=0ADo You Yahoo!?=0ATired of = spam? Yahoo! Mail has the best spam protection around =0Ahttp://mail.yahoo= .com =0A=0A-- =0AMySQL Windows Mailing List=0AFor list archives: http://lis= ts.mysql.com/win32=0ATo unsubscribe: http://lists.mysql.com/win32?unsub= [email protected]=0A=0A=0A--=0AMySQL Windows Mailing List=0AFor list arc= hives: http://lists.mysql.com/win32=0ATo unsubscribe: =0A http://lists.my= sql.com/[email protected]=0A=0A=0A=0A=0A=0A_________________= _________________________________=0ADo You Yahoo!?=0ATired of spam? Yahoo!= Mail has the best spam protection around =0Ahttp://mail.yahoo.com -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]