I'm running MySQL 3.23, so it seems I can't change the ft_min_word_len variable to 3.
Are there any creative ways to do this?
There are so many 3-letter words that people search for... sigh...
Creative ways to get around fulltext 4 char limitation?
Moderator: General Moderators
did you look at this?
http://bugs.mysql.com/bug.php?id=845
http://bugs.mysql.com/bug.php?id=845
You're ignoring what I wrote. I stated that I DID read the manual.
This is the gist of my post:
"I'm running MySQL 3.23, so it seems I can't change the ft_min_word_len variable to 3. "
This is from the manual:
"The minimum and maximum length of words to be indexed is defined by the ft_min_word_len and ft_max_word_len system variables (available as of MySQL 4.0.0)"
MySQL 3.23 vs MySQL 4.0.0
This is the gist of my post:
"I'm running MySQL 3.23, so it seems I can't change the ft_min_word_len variable to 3. "
This is from the manual:
"The minimum and maximum length of words to be indexed is defined by the ft_min_word_len and ft_max_word_len system variables (available as of MySQL 4.0.0)"
MySQL 3.23 vs MySQL 4.0.0
I wasn't ignoring your post, I was being a total knob by not even reading it. My apologies.
What if you padded your 3 character search strings with spaces. If I'm searching for 'IRA', 'IRA ' should also work should it not?
What if you padded your 3 character search strings with spaces. If I'm searching for 'IRA', 'IRA ' should also work should it not?
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.