RE: [PHP] Keyword & exact phrase search

I'd like to agree. But i've speant a lot of time investigating, learning, and expirimenting with Full Text search and what I've found is that first, full text does not always return the right results and second and perhaps more important in my situation is that full text search doesn't work on BLOB fields. -----Original Message----- From: Justin French [mailto:justin@indent.com.au] Sent: Thursday, August 15, 2002 8:37 AM To: David Buerer; 'php-general@lists.php.net' Subject: Re: [PHP] 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 > > >