Re: full-text search problems (newbie)

2002-10-13 Thread Alan
On Sun, Oct 13, 2002 at 10:58:53PM +, Sergei Golubchik wrote: > Hi! > > On Oct 13, Alan wrote: > > > > mysql> select title from content where match > > (title,center_content,right_content) against ('updates'); > > +-+ > > | title | > > +-

Re: full-text search problems (newbie)

2002-10-13 Thread Sergei Golubchik
Hi! On Oct 13, Alan wrote: > > mysql> select title from content where match > (title,center_content,right_content) against ('updates'); > +-+ > | title | > +-+ > | eXI Systems' Latest Updates | > +-

Re: full-text search problems (newbie)

2002-10-13 Thread Alan
On Sun, Oct 13, 2002 at 02:48:38PM -0500, Paul DuBois wrote: [snip] > >As far as I can tell, this *should* be working. Can anyone help please? > > Try dropping the FULLTEXT index and then add it again. (Alternatively, > dump and reload the table). I did drop the table this morning, just in cas

Re: full-text search problems (newbie)

2002-10-13 Thread Paul DuBois
At 11:11 -0700 10/13/02, Alan wrote: >Hi folks, new to the list, hoping I'm posting to the right one. > >I've been using the full-text search for a clients site and it works >great... the only problem is I want to change the minimum word length >from 4 to lower, such as 2 or 3. Reading the docs t

full-text search problems (newbie)

2002-10-13 Thread Alan
Hi folks, new to the list, hoping I'm posting to the right one. I've been using the full-text search for a clients site and it works great... the only problem is I want to change the minimum word length from 4 to lower, such as 2 or 3. Reading the docs this is simple, and I followed the instruct