title: MySQL query to check if this is same product
body: <p>I'm working on price comparision program for 3 website. Each website can have same product with other websites but product name is not exactly same (EX: "Asus X553MA-XX102H Intel Celeron N2930 4GB 1TB DVDRW 15.6 Windows 8.1" and "Asus X553MA 15.6 Inch Intel Celeron 4GB 1TB Laptop" is one product but the name is not exactly same). </p>
  
  <p>I was crawled data from 3 website to mysql table called crawledproduct(which has 3 columns: sourceurl, productname, price).</p>
  
  <p>Please help me write a MySQL query command to find all same product by product name. </p>
  
  <p>EX: <code>Select * from crawledproduct where [Similar with 'Asus X553MA 15.6 Inch Intel Celeron 4GB 1TB Laptop']</code></p>
  
  <p>Thanks for any help.</p>