full text search - MySQL query to check if this is same product -

i'm working on price comparision program 3 website. each website can have same product other websites product name not same (ex: "asus x553ma-xx102h intel celeron n2930 4gb 1tb dvdrw 15.6 windows 8.1" , "asus x553ma 15.6 inch intel celeron 4gb 1tb laptop" 1 product name not same).

i crawled data 3 website mysql table called crawledproduct(which has 3 columns: sourceurl, productname, price).

please me write mysql query command find same product product name.

ex: select * crawledproduct [similar 'asus x553ma 15.6 inch intel celeron 4gb 1tb laptop']

thanks help.

i assuming name of product given input user or know product name wanna compare. need 'like' clause in query. suppose want search word 'axus':

select name crawledproduct      productname '%axus%' 

% called wildcard. tells dbms want search pattern. suppose want search "axus" in each row in column a:

like '%axus' //this means give rows have entries in column ending axus  'axus%' //this means give rows have entries in column starting axus  '%axus%' //this means give rows have entries in column contain word axus. 

ofcourse, need enter search term in order products. if same product not have keyword specified, won't displayed in output. there several other ways search pattern in database table. might wanna bit of research on that, because beginner , don't have knowledge yet. luck! kudos! :)