Coding a site search...

Any good examples or programs?

[hdpt00]

I am starting a rather large content based site. I need a search for my site that will handle multiple words, etc. that I can have search a certain field in my db (mySQL). Are there any good places to learn how to do this so it is very efficient and speedy or are there any scripts that already do this that you could recommend with minimal modifications?

Thanks,
Brandon

[WhosAWhata]

i'd recomend taking a look at
The Resource Index [php.resourceindex.com]
run a search on search scripts

[httpwebwitch]

My favourite is the Heathco Search engine - it runs entirely in PHP/MySQL and uses good methods for fast response even on large sites. I have it running on a high-traffic site with about 1300 pages and it handles the load well (average search time for a single word query is about 1.7sec).

I can't put the URL here, but a search for HEATHCOSOFT will lead you in the right direction.