fulltext question

2013-11-26 Thread Jim Sheffer
Hello all- I have a question on searching via fulltext. I have the following SQL statement: var('SQLResultsID') = 'select *, MATCH (product_id,product_name,product_desc) AGAINST("' + $sqlKeywordSearch + '") AS SCORE from products WHERE MATCH (product_id,product_name,product_desc) AGAI

Re: MySQL fulltext. Question about the stopword list

2003-01-10 Thread Sergei Golubchik
Hi! On Jan 07, Erlend Hopso Stromsvik wrote: > > What I can easily do without breaking 4.0.x "gamma" status, is to add > > command line switch --disable-fulltext-stopwords. It can help as a > > temporary solution, untill a proper fix - per-index options, that is - > > will be implemented. > > Tha

RE: MySQL fulltext. Question about the stopword list

2003-01-08 Thread Erlend Hopso Stromsvik
> What I can easily do without breaking 4.0.x "gamma" status, is to add > command line switch --disable-fulltext-stopwords. It can help as a > temporary solution, untill a proper fix - per-index options, that is - > will be implemented. That would be helpful for me, but what about Thomas Spahni's

FW: MySQL fulltext. Question about the stopword list

2003-01-08 Thread Erlend Hopso Stromsvik
Resending this, since the first one didn't seem to get posted on the MySQL list. > -Original Message- > From: Erlend HopsÛ StrÛmsvik > Sent: 7. januar 2003 10:18 > To: [EMAIL PROTECTED] > Subject: RE: MySQL fulltext. Question about the stopword list > > > &

Re: MySQL fulltext. Question about the stopword list

2003-01-07 Thread Thomas Spahni
On Mon, 6 Jan 2003, Sergei Golubchik wrote: > > Does the stopword list have to be 'hardcoded' in myisam/ft_static.c? > > No, of course, it has not. > The problem is, that I cannot implement something like > >CREATE TABLE ... ( ... FULLTEXT (...) WITHOUT STOPWORD LIST ) > or >CREATE TABLE .

Re: MySQL fulltext. Question about the stopword list

2003-01-06 Thread Sergei Golubchik
Hi! On Jan 06, Erlend Hopsø Strømsvik wrote: > > Hi > > I'm currently using MySQL (4.0.4 recompiled) as our database for storing > information about books. > There are about 1.5mill book titles + other information in the database now. > > The fulltext search capabilities of MySQL have turned ou

MySQL fulltext. Question about the stopword list

2003-01-06 Thread Erlend Hopsø Strømsvik
Hi I'm currently using MySQL (4.0.4 recompiled) as our database for storing information about books. There are about 1.5mill book titles + other information in the database now. The fulltext search capabilities of MySQL have turned out to become very good with the 4+ version and with a little tw

Fulltext question

2001-10-18 Thread Jeroen Geusebroek
Hi there, I am trying fulltext to speed up my queries; but what would the query line be, when I would like to match the phrase: "This is a text"? With a like query i would do "WHERE column LIKE '%This Is a text%';" I've tried "MATCH column AGAINST("'+this +is +a +test'");" but this returns, all