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
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]
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?
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.
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/
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
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