Has anyone bumped into or written a set of good searching routines? I need
to search across one,two, or three fields in an MySQL database in either
exact phrase (easy) or keyword with relavence (difficult.)  I'm thinking
something like a google/yahoo style search.  I've tried MySQL full text
searches, but the results it returns seem to be just a little to broad and
you end up with a bunch of irrelevant results.  

With respect to the database size that I'm searching in, right now it's
about 20MB but I'm guessing that within the next 24 months it will be up
around 2GB.  The first field I'm searching in is a CHAR(255) field.  The
second field  is a small blob and usually is only about 1 paragraph of text.
The thrid field is an entire HTML document and can be many many pages long.

Any help is appreciated,

Reply via email to