Hi,
> I've written a search engine that searches for jobs in a database based > on keywords. I'm assembling a string of sql and then submitting it to > the database based on the user's search criteria. It's working but is It sounds like you are writing a web front end for mysql. I'm not sure about modules on cpan about that specifically. If you wanted to get a bit more fancy, you might try DBIx::FullTextSearch. This module is nice, though mysql specific. It creates an index of your content (event rows in a db), and allows the user to perform boolean searches on that index. Word stemming is also available by installing a seperate module which FullTextSearch uses. It's a tad sluggish when the number of rows gets to be above 40,000, but certainly not unusable. hth, matt >I don't want to reinvent the wheel and I'm sure this has been done a >zillion times, so does anyone know of a module in CPAN that I can use >for this? I'm using MySQL on the back end and DBI under mod perl which >runs as a handler. -- ## Matt J. Avitable ([EMAIL PROTECTED]) ## General Partner / Programmer ## Escapement Arts And Media ## http://www.escapement.net/ ## Phone: (804) 400-0605