>> 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
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 fullttext?
Thanks for the
Ari Denison wrote:
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 may from the st
- 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
Ari, what's the result of
mysql -N -e "SHOW VARIABLES;" | grep 'ft_min_word_len'
? Default is 4 but you need to reduce this to 3 (or even to 2, if you
want to match first_name against('Al')).
Regards, Thomas Spahni
On Sun, 5 Sep 2004, Ari Denison wrote:
> Hello list -
> I'm trying to do a
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 may from the stopwords list and ha