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

Re: full text search problems

2002-08-26 Thread Thomas Spahni
On Sun, 25 Aug 2002, andy wrote: > Hi there, > > I am trying to write a php script to perform a full text search on a mysql > db. I do a match against... and it digs out some results out of the db. > > There are 2 problems: > > 1. > 2. Is it possible with php to underline the keyword inside t

Re: full text search problems

2002-08-25 Thread Dicky Wahyu Purnomo
Pada Sun, 25 Aug 2002 16:33:51 +0200 "andy" <[EMAIL PROTECTED]> menulis : > Hi there, > > I am trying to write a php script to perform a full text search on a mysql > db. I do a match against... and it digs out some results out of the db. > > There are 2 problems: > > 1. How can I restrict the

full text search problems

2002-08-25 Thread andy
Hi there, I am trying to write a php script to perform a full text search on a mysql db. I do a match against... and it digs out some results out of the db. There are 2 problems: 1. How can I restrict the results to e.g. 100 characters, but to make sure the keyword is within this 100 characters