title: How to prevent replacing two values in the same field?
body: <p>Can anyone tell me how to prevent this PHP code replacing two values?</p>
  
  <pre><code>$sql2="UPDATE users SET urls = replace(urls, 'http://someurl.com', '') WHERE uname='$username'";
  $result2=mysql_query($sql2);
  </code></pre>
  
  <p>For example, the field "urls" contains this:  </p>
  
  <blockquote>
    <p><a href="http://someurl.com" rel="nofollow">http://someurl.com</a><br>
    <a href="http://someurl.com/page.html" rel="nofollow">http://someurl.com/page.html</a></p>
  </blockquote>
  
  <p>Using the above code removes both URLs, leaving just the "/page.html".<br>
  How do I make sure it only deletes the value and doesn't remove anything else.  </p>