If you're talking about a fulltext search, DBIx::FullTextSearch may be your answer (it uses mysql)...

I don't know if I should mention it but, for really simple (and dirty) search on several text field in your table,LIKE and CONCAT in your sql statement would do the trick (but so slowly...)

"Trying to be a SMART lamer" (thanx to Merlyn ;-)