using MySQL LIKE to select an escaped string in database
===

I use mysql_real_escape_string on stuff that gets put in my database, so something like Bob's Shop would turn into Bob\'s Shop. And, for example, if I try to select all the entries that contain Bob\'s, my select statement looks like: SELECT * FROM tbl WHERE name LIKE '%Bob\\\\\'s%' and for whatever reason, it doesn't work, even though it makes complete sense that it would work.