Re: [PHP] Keyword & exact phrase search

2002-08-16 Thread Jason Wong
On Thursday 15 August 2002 23:50, David Buerer wrote: > Because to my knowledge the limitation of a TEXT field is 64K. I need to > store entire documents in the database which far exceed the 64K limitation. > Given that criteria, the only option is to use blob fields which have an > upper limit of

Re: [PHP] Keyword & exact phrase search

2002-08-15 Thread Justin French
ing my own from scratch if all that didn't work out... Justin French > -Original Message- > From: Justin French [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 9:08 AM > To: David Buerer > Subject: Re: [PHP] Keyword & exact phrase search > >

RE: [PHP] Keyword & exact phrase search

2002-08-15 Thread David Buerer
[mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 9:08 AM To: David Buerer Subject: Re: [PHP] Keyword & exact phrase search Why would you have text in blob fields? Justin French on 16/08/02 1:25 AM, David Buerer ([EMAIL PROTECTED]) wrote: > I'd like to agr

RE: [PHP] Keyword & exact phrase search

2002-08-15 Thread David Buerer
doesn't work on BLOB fields. -Original Message- From: Justin French [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 8:37 AM To: David Buerer; '[EMAIL PROTECTED]' Subject: Re: [PHP] Keyword & exact phrase search I only just started getting into this, but it se

Re: [PHP] Keyword & exact phrase search

2002-08-15 Thread Justin French
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 ([EMAIL PROTECTED]) wrote: > Has anyone bumped into or written a set of good searching r

[PHP] Keyword & exact phrase search

2002-08-15 Thread David Buerer
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 searc