List:General Discussion« Previous MessageNext Message »
From:Taco Fleur Date:April 13 2006 12:14am
Subject:RE: Fulltext and reserved words
View as plain text  
Thanks for that, you saved the day.
I am now trying to change that variable, I did a search through the ini
files and changed the only file that had ft_min_word_len in it to
ft_min_word_len = 2 restarted the server did SHOW VARIABLES and it still
shows as 4, not sure what I am missing, going through the documentation but
just can't find anything specific. 


Kind regards,
 

Taco Fleur 

Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au an industry leader with commercial
IT experience since 1994 .

*	
	Web Design and Development 
*	
	SMS Solutions, including developer API
*	
	Domain Registration, .COM for as low as fifteen dollars a year,
.COM.AU for fifty dollars two years!


-----Original Message-----
From: Dan Nelson [mailto:dnelson@stripped] 
Sent: Thursday, 13 April 2006 3:56 AM
To: Taco Fleur
Cc: mysql@stripped
Subject: Re: Fulltext and reserved words

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1



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