MySQL Search (Sort by Relevance)

Posted by atif089 on Stack Overflow See other posts from Stack Overflow or by atif089
Published on 2010-03-11T11:50:23Z Indexed on 2010/03/21 20:11 UTC
Read the original article Hit count: 165

Filed under:
|
|

Hi guys,

Can any one help me how to sort rows by relevance for the following criterion ?

tbluser


First Name Last Name

tbleduc


School College University

On the search form the user has following fields

Name School College University

Where School College and University are Optional..

And Name is split into 2 words (other words in middle are omitted), first word is taken as first anme and last word as last name..

Now I would like to implement search based on relevance.

Thanks for the help :)

© Stack Overflow or respective owner

Related posts about mysql

Related posts about search