title: Which is the best and fastest way to compare two urls?
body: <p>I have two tables with list of urls fetched from different sources.</p>
  
  <p>I want to find the common entries and put them in separate table.</p>
  
  <p>This is what I'm doing: </p>
  
  <ol>
  <li>find md5 hash of url while fetching them.</li>
  <li>Store them in a column.</li>
  <li>I fetch one table as an array, run a loop through it and insert the values from other table where md5 hash is the same.</li>
  </ol>
  
  <p>EDIT: Should I strip the urls of "http://' and 'www.' </p>
  
  <p>I want to know any other method, which is better and faster, using which I can perform the above.</p>
  
  <p>I am using PHP + MySQL</p>