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




Reply via email to