Re: FULLTEXT search pattern syntax

2002-05-06 Thread Vadim P.
Sergei, here: RH7.2/2.4.9-31/Dual P-III 866MHz/MySQL4.0.2 A snapshot from a live database, sorry, couldn't prepare a more detailed example: -- select tdate, left(header,125) from archivel where match (header) against ('"donald rumsfeld"' in boolean mode); ==> 188 rows in set (0.

Re: FULLTEXT search pattern syntax

2002-05-06 Thread Sergei Golubchik
Hi! On May 06, Vadim P. wrote: > Hi, > > It's not quite clear from the manual, but it appears that queries with > FULLTEXT search patterns like this: > > MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")') > > don't produce the result desired, that is, multiple ".." elements are

RE: FULLTEXT search pattern syntax

2002-05-06 Thread Gurhan Ozen
2002 12:07 PM To: [EMAIL PROTECTED] Subject: Re: FULLTEXT search pattern syntax Of course, I forgot to mention 'IN BOOLEAN MODE'. ... MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")' IN BOOLEAN MODE) ... > "Vadim P." w

Re: FULLTEXT search pattern syntax

2002-05-06 Thread Vadim P.
Of course, I forgot to mention 'IN BOOLEAN MODE'. ... MATCH (some_text_field) AGAINST ('("red pepper") ("green bean")' IN BOOLEAN MODE) ... > "Vadim P." wrote: > > Hi, > > It's not quite clear from the manual, but it appears that queries with > FULLTEXT search patterns like this: > > MATCH