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 other

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 PROTECTED]

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?

FULLTEXT Exact phrase search including quotes

2005-02-24 Thread HMax
Hi list, I'm trying to figure out how to use the exact phrase search in fulltext boolean mode when the phease to search includes double quotes. For instance, what if I want to search this exact phrase : I like football on TV I think I've tried all the solution I'm aware of without any results.

fulltext - exact phrase

2002-05-29 Thread ddd
Hello I have a question, is possible to search on mysql 4.0 in fulltext index the exact phrase ? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

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 capability

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 is