Re: Single Quotes in a Select Statement

2001-08-17 Thread Philip Mak
On Fri, 17 Aug 2001, Cal Evans wrote: > Select * from product where title = 'This title has a \' in it.'; > > This query does not work. Can anyone tell me how to build a query that will > return that title? Are you sure you're not overlooking something? I just tried the following commands and h

Single Quotes in a Select Statement

2001-08-17 Thread Cal Evans
Greetings MySQLers! This messages is about MySQL. (had to put that in for the spam filter) I have a record in my database: productID Title 4 This title has a ' in it. In the database, this is actually stored as: productID Title 4 This title has a \' in it. I have a query: Se