Bug #2140 in full-text match failed when use 'OK'
Submitted: 17 Dec 2003 5:32 Modified: 17 Dec 2003 9:01
Reporter: David Palomo Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.0.1 OS:Linux (Linux, windows)
Assigned to: CPU Architecture:Any

[17 Dec 2003 5:32] David Palomo 
Description:
match failed when you use the string 'OK'

How to repeat:
select * from TABLE_NAME where MATCH (FIELD_NAME) AGAINST ('OK')
[17 Dec 2003 9:01] Indrek Siitan 
This is expected behaviour, as "OK" is shorter than the minimum length of
full-text indexed words, set by the "ft_min_word_len" variable.

And remember, if you change it, you need to rebuild your full text indexes.
[17 Dec 2003 9:09] David Palomo 
I don't know if this is a bug, but is only when I use 'OK' word. With others words like 'wc' or 'te' runs fine. Thanks
[17 Dec 2003 9:12] Dean Ellis 
"OK" is in the stopwords list...
[17 Dec 2003 9:14] David Palomo 
What can i do to use this word? Is there any method without using where ... like   '% ok %'.....  ???