Searching db content and show results based on relevancy

[FateFirst]

Hi.

I currently have a basic CMS that I wrote for a friend.

I am looking to introduce a 'Site Search' feature. Just searching through [field_x] & [field_y] for

and returning results.

My trouble is...how would you work out the relevancy. I was thinking about just having it so the more times the word appears in the 'fields' the more relevant and as a result these records would be displayed first and cycle down.

Im just a little unsure how to produce this without masses of irrelevant code. Anyone have any code samples/tutorials or just general ideas about how to handle this?

I appreciate the help.

Thanks!

- FateFirst