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:[EMAIL PROTECTED] +27 21 447 7440 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/[EMAIL PROTECTED]
