title: mysql - replace string with percentage sign
body: <p>In a particular column, I need to batch replace all instances of "<a href="http://%20" rel="nofollow">http://%20</a>" with "http://". The aim is to get rid of the %20 HTML entity which denotes an empty space.</p>
  
  <p>I've tried</p>
  
  <pre><code> update content set fulltext = replace(fulltext,'http://%20','http://');
  </code></pre>
  
  <p>but keep getting an error code #1064.</p>
  
  <p>content is the table name and flutist is the column.</p>
  
  <p>I guess something must be done about the percentage sign, since MySQL parses to as a wildcard.</p>
  
  <p>MySQL 5.5.43 on Ubuntu 14.04 LTS.</p>