Re: Keyword & exact phrase search

I only just started getting into this, but it seems that a LOT of the work is done for you with MySQL's FULLTEXT stuff.... Check it out in the MySQL manual. Justin French on 16/08/02 12:59 AM, David Buerer (david@pladesigns.com) wrote: > 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, > David > > >