[RESOLVED] writing a good search function?

[Yari]

I would like to build a search function for a custom-built CMS.

Apart from just searching for a keyword in the page title and text, I would like to sort the results according to where the keyword was found.

E.g.
If I search for 'contact', and they keyword is found in the page title of page 1, but only in the body of page 2, it would show page 1 at the top of the search results.

Some ideas I had for doing this are:

1. do a MySQL search 'SELECT * FROM pages WHERE title LIKE '%$keyword%'
   save results into an array

2. do another MySQL search 'SELECT * FROM pages WHERE body LIKE '%$keyword%'
   save results into an array
   merge arrays 1 and 2, sorting by array 1 (and removing duplicates)

Not sure how to just grab a snippet of text from MySQL when searching...
Another issue is, do I search for a keyword 'string', or split up the keywords when searching?

Any thoughts?

[sneakyimp]

I had a post similar to this which u might find helpful:
http://phpbuilder.com/board/showthread.php?t=10340672

[dagon]

Full-text searching is the way to go

http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

[Yari]

Thanks, I think I will go for FULLTEXT indexing using MySQL (cheers Dagon), and definitely explode the search term (thanks Sneakyimp)...

That should do it, the rest is up to me in PHP.

Thanks guys!