Search engine

[Towle92]

hi,

I'm wanting to create an advanced search on a asp.net page that when a phrase is entered it runs a command and returns results based on relevance

so my example would be to search for the phrase "big red bus"

it would then search my sql table

id | result

1 | green bike

2 | silver bus

3 | red bus

4 | red car

5 | big red bus


and would then display the results via relevance or how many words it matched up with

so the order displayed to my user would be


5 | big red bus

3 | red bus

2 | silver bus

4 | red car


any help on where to look for relevant code or the best method to go about this would be great

thanks

Continue reading...