I have a table in mysql database(`product{id, name, category}`) which consists of hundreds of records. 

Now a new product is added with the same fields and i want to search for the fields and match it with others records so that i could found the best match of product.

My question is what is the best approach for this, should i search through the name of product but what if there are more than one match with that names.

should i use something like this

`SELECT * FROM table_name WHERE column1 LIKE '%column1%' OR column2 LIKE '%column2%'`