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:

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?

Things I have tried: Select * from product where title = 'This title has a ' in it.'; Select * from product where title = 'This title has a \' in it.'; Select * from product where title = 'This title has a ''' in it.'; Select * from product where title = 'This title has a '' in it.';

TIA for any help, Cal http://www.calevans.com