It also depends on what you need it to search in the database, what and how the results are to be displayed etc. etc. etc.
We have a search script that is very generic and can search any mysql database, using the search script in combination with a html form, it can pull any information from the database as long as it's exact, it doesn't do fuzzy searching nor in exact searching, it only does exact matches, thus it's only really good for really getting exactly what you want out of a mysql database, and it can be hooked up to any mysql database to search any or all fields in the database.
Unfortunately the code is so sloppy that it would be near impossible for someone less than a perl guru to make heads or tails out of it.
Harrison
"I've got if's pretty good, but that's about it"