title: How to store special characters (', ", &, etc) in mysql database, so they can be searchable?
body: <p>Im having a small problem with storage of special characters like quotes, double quotes and ampersands. I put every POST request through mysql_real_escape_string(), and when I add a string like <code>"That '70s Show"</code> it gets stored as <code>"That &amp;#x27;70s Show"</code> in the mysql DB. When I echo it out, it works fine... but when I try to run a % $string % search for <code>"That '70s Show"</code>, it will not find the record. I have magic_quotes disabled. </p>
  
  <p>How can I get around this?</p>