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*@jamwarehouse.com
+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/my***********...ie.nctu.edu.tw