Database query review and recomendation
Closed - This job posting has been filled and work has been completed.
Code is written in PHP Codeigniter and Mysql
We require a query that ranks and returns 20 of the closest products based on there descriptions. We have a database of 150,000 products with descriptions of 250 chars some words are shortened or abbreviated (mnthly,mly = monthly) .We need to return products based on there relevance to a product description. this may require separate tables to rank words or groups ("ring binder" or "view binder") or filter out words that are not helpful
The initial project is to test the theory and to see if this is possible if it is successful we will be require the applicant to build the code - build tables, and further improve it's efficiency and speed