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