Re: FULLTEXT indexes and select query problem

2003-03-03 Thread Paul DuBois
At 21:56 -0500 3/3/03, Stitchin' wrote: I found some stuff in the mySql manual about setting columns as fulltext indexes for fulltext searches and the syntax is WHERE MATCH (column names...) AGAINST (the search stuff) So I went in and did an alter table statement to set my four search columns to

RE: fulltext indexes

2003-02-27 Thread Salada, Duncan
Maybe this could help? Try changing the name of the index on the second table you 've created Thanks for the idea, but I think I've discovered the problem. Perhaps I chose my search phrase a little TOO well. It seems the problem occurs because of the 50% restriction for fulltext searching. Fr

Re: fulltext indexes

2003-02-27 Thread ngfentis
Hello Duncan, Thursday, February 27, 2003, 4:00:31 PM, you wrote: SD> I having some strange things occur with doing fulltext searches. I'm not SD> exactly sure how to tackle this problem, so I figured I would send it out SD> and see if anyone has any ideas or has seen this before. SD> Backgroun

Re: fulltext indexes for innodb?

2001-09-04 Thread Philip Molter
On Thu, Aug 30, 2001 at 01:44:56PM +0200, Sergei Golubchik wrote: : Hi! : : On Aug 30, Alexander wrote: : > Hello, mysql team! : > : > Any chance (in the near future) to get FullText indexing working with innodb : > table handler? : > : > Alexander : : I doubt it will be done it the near futur

Re: fulltext indexes for innodb?

2001-08-30 Thread Alexander
Hi , Ahh... Ok, thanks for reply. Fulltext searching can be done in application level, but productivity of this solution... > Hi! > > On Aug 30, Alexander wrote: > > Hello, mysql team! > > > > Any chance (in the near future) to get FullText indexing working with innodb > > table handler? > > > >

Re: fulltext indexes for innodb?

2001-08-30 Thread Sergei Golubchik
Hi! On Aug 30, Alexander wrote: > Hello, mysql team! > > Any chance (in the near future) to get FullText indexing working with innodb > table handler? > > Alexander I doubt it will be done it the near future (unless a customer would like to pay for the feature, of course). Regards, Sergei --