Matching escaped strings

[Rob]

Hi all,

I have the following info in my database

ID | Name
=============== =
1 | Author\'s

As you can see, the name value has been escaped. Now, the question is,
how do you match on a value that has escaped charaters? I've tried the
following

SELECT * FROM table WHERE Name = 'Author\'s'

SELECT * FROM table WHERE Name LIKE 'Author\'s'
SELECT * FROM table WHERE Name = '%Author\'s%'
SELECT * FROM table WHERE Name = 'Author''s'
SELECT * FROM table WHERE Name = "Author\'s"
SELECT * FROM table WHERE Name = "Author's"

And none of them work. Any suggestions

Thanks

---
Rob

*************** ***********
Rob Cherry
mailto:ro*@jamw arehouse.com
[phone]
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
*************** ***********

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw