List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:April 12 2006 5:56pm
Subject:Re: Fulltext and reserved words
View as plain text  
In the last episode (Apr 12), Taco Fleur said:
> I am in need to search for sql reserved words with MATCH AGAINST it
> turns it doesn't return anything when I feed it a reserved word like
> 'sql' is there anything I can do about that?

By default the full-text indexer skips words less than four characters
long.  If you set ft_min_word_len=3 and rebuild your index, "sql" should
get indexed.

http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html

-- 
	Dan Nelson
	dnelson@stripped
Thread
Fulltext and reserved wordsTaco Fleur12 Apr
  • Re: Fulltext and reserved wordsDan Nelson12 Apr
RE: Fulltext and reserved wordsTaco Fleur13 Apr
  • RE: Fulltext and reserved wordsmysql13 Apr
RE: Fulltext and reserved wordsTaco Fleur13 Apr
  • RE: Fulltext and reserved wordsmysql13 Apr