Re: FULLTEXT Exact phrase search including quotes

2005-02-28 Thread Gleb Paharenko
Hello. >and I want to search for this exact phrase, including double quotes, You can't do this, because fulltext search operates with "words", and double quotes not a "word". Also an order of the sequence of words doesn't have a sence for a fulltext search. CheHax <[EMAIL PROTECT

Re: FULLTEXT Exact phrase search including quotes

2005-02-28 Thread CheHax
Alright, my example phrase wasn't a good one. Let's try this now: We have a table with company activities. On of them is : "Plastique ou carton" and some others are in "Plastic, carton" Plastique <> Plastic (different language) What we want, is to find exactly "Plastique ou carton" and not the o

Re: FULLTEXT Exact phrase search including quotes

2005-02-25 Thread Gleb Paharenko
Hello. At first: from your phrase with default values for the FULLTEXT parameters there is the only one meaningful word - football. Because 'I', 'on', 'TV' has less than 3 characters. 'like' is in the stopword list. Quotes '"' - are skipped from the search. What query do you use to search? D

Re: fulltext - exact phrase

2002-05-29 Thread Egor Egorov
ddd, Thursday, May 30, 2002, 12:10:07 AM, you wrote: d> I have a question, d> is possible to search on mysql 4.0 in fulltext index d> the exact phrase ? "Phrase search" will come in 4.0.2... d> thanks -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email

Re: fulltext - exact phrase

2002-05-29 Thread Philip Mak
On Wed, May 29, 2002 at 02:10:07PM -0700, ddd wrote: > I have a question, is possible to search on mysql 4.0 in fulltext > index the exact phrase ? http://www.mysql.com/doc/F/u/Fulltext_Search.html suggests that it is possible. Here is the relevant excerpt: The boolean full-text search capabilit