DB search - sort by relevance

We have a MySQL InnoDB table in our database where we want to perform searches on a single field (text).

Upon search, the search results must be outputted to the client sorted (descending) by relevance, based on how many occurrences the search term have in each recordset of the field in question. The user will then be able to change the sorting to sort by date (descending).

The search must be able to use the LIKE parameter, and calculation of number of occurrences must also be counted towards the LIKE parameter.

The search must be available to client in the following three ways; all words, some words, exact match, meaning that there will be needed three different types of SQLs, one for each search method.

Changing the table to MyISAM is not an option, and the technique developed must be easy to clone to other table searches.

The website where the search should be available, is PHP (Symfony, Doctrine platform). Code must comply to PHP.

Habilidades: PHP

Veja mais: sort relevance php, sort sort sort, sort sort, sorting method, single match, php developed by, c text search, code search, php search database sort relevance, php search sort relevance, php sort relevance, search the we, search match, relevance, mysql code search, mysql sort field, mysql sort, search results php, recordset, mysql search table

Acerca do Empregador:
( 82 comentários ) karachi, Pakistan

ID do Projeto: #683752

7 freelancers estão ofertando em média $179 para esse trabalho


Hi,I am Interested and [login to view URL] check our users feedback on [login to view URL] you.

$250 USD in 3 dias
(37 Comentários)

The project will be completed within few hours. Please check PMB for more details. Best Regards

$100 USD in 2 dias
(101 Comentários)

I can help you, please check your PMB.

$100 USD in 3 dias
(6 Comentários)

I have done similar job.. plz check the PMB for further details!!!

$350 USD in 10 dias
(0 Comentários)

Hi, I' ve done similar job before so I have code (php classes) that I could reuse in order to build your functionality. My area of expertise is oop PHP and mysql databases. I guarantee that functions will be easy to Mais

$100 USD in 3 dias
(0 Comentários)

I am readyto start rigth now.

$250 USD in 10 dias
(1 Comentário)

We are happy to start on this immediately and are PMing you our initial thoughts on your problem.

$100 USD in 6 dias
(0 Comentários)