Hi
I have configured MySQL to ignore stopwords from file
/etc/my.stopwords. While playing around with myisam_ftdump
I found that my fulltext index contains about a dozen words which are so
common that they have a negative weight.
Would it be a good idea to include these words in the stopwords
>> Sticking with the May example... I would like to be able to return
>> results for only students named May or Maya, but not Mayra, Jessica-May,
>> or Maylita.
SELECT * FROM students WHERE first_name LIKE 'May_'
_ in like means any single character
% in like means arbitrary number of characters
Ari Denison wrote:
Sticking with the May example... I would like to be able to return
results for only students named May or Maya, but not Mayra, Jessica-May,
or Maylita.
With a definite list, you can
SELECT * FROM students WHERE first_name IN ('May', 'Maya');
This would use a simple index on f
Sticking with the May example... I would like to be able to return
results for only students named May or Maya, but not Mayra,
Jessica-May, or Maylita.
The other example would be simple wild cards. Something like steve*
returns steve, steven, cody-steven, Stevenmikel, steve-allen.
Thanks for a
Ari Denison wrote:
the ft_min_word_length is now set to 3. That did the trick. Many thanks.
I forgot to mention that I need to be able to perform boolean searches
on the first_name field.
If it's possible to do boolean searching on a normal index, should I be
doing that instead of using a fulltte
e wit the first_name of
May.
And, yes, I've removed may from the stopwords list and have reindexed
the field but still return no records.
Any idea how to get my May students to show in full text search
results?
Thanks,
Ari Denison
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've removed may from the stopwords list and have reindexed
the field but still return no records.
Any idea how to get my May students to show in full text search results?
Thanks,
Ari Denison
Others have already pointed out a couple reasons this might not work.
Do I understand correctly that y
- Original Message -
From: "Ari Denison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 06, 2004 1:15 AM
Subject: Full Text Stopwords
> Hello list -
> I'm trying to do a full text search for the the string "May" usi
Hello list -
> I'm trying to do a full text search for the the string "May" using
> the following query:
>
> SELECT * FROM students WHERE MATCH(first_name) AGAINST("May");
>
> There are a number of students in that table wit the first_name of May.
&g
Hello list -
I'm trying to do a full text search for the the string "May" using
the following query:
SELECT * FROM students WHERE MATCH(first_name) AGAINST("May");
There are a number of students in that table wit the first_name of May.
And, yes, I've removed m
ating with spaces, commas, etc.
To see what MySQL is currently using as stopwords, you know about the
ft_stopword_file variable, right? That tells you the file, if the
built-in list isn't being used. The built-in list is defined in
myisam/ft_static.c as it says there in the manual. If you wan
In the docs is says that you can define your own stopwords file for fulltext
searching. The following is under show variables...
ft_stopword_file The file from which to read the list of stopwords for
full-text searches. All the words from the file will be used; comments are
not honored. By
Hi,
Is there a way to prevent the 50% occurence threshold in mysql's
fulltext search logic that causes words that appear in more than 50% of
records to be considered stopwords? I have a table that has less than
1000 records and would like to do a fulltext search on two columns and
have
Is there any way to remove the treatment of words three letters and under
being treated as a stopword when performing a query of a full text index on
a table. If it is a recompile of MySQL is there a good resource on how to do
this... I'm a newbie to the world of compiling MySQL
thanks
Chris
D
Is there any other way of using a stopword list so I can speed up and
improve the quality of my queries in a full text search without recompiling
mySQL
thanks
Chris
Dr Christopher Thorpe
Information Architect
GenomeBiology - biology for the post-genomic era
w http://www.genomebiology.com
15 matches
Mail list logo
