I've got a PHP/MySQL installation. I am focusing on a course that utilizes a MySQL Fulltext search. I wish to lessen the min word length to 3. I understand I'm able to do that by altering the
ft_min_word_length global variable and restarting MySQL.
My problem would be that the MySQL server is running other databases, including two Wordpress blogs. Basically change that global variable, will this affect/muck in the Wordpress posts search? What formula does Wordpress use? Will it use MySQL FULLTEXT?
It is possible to method to set
ft_min_word_length for just one database? Must I be worried about it?
I am using MySql 5..5, PHP 5, and Wordpress 2.8 on IIS 6.
You are able to discover if full text index has been used...
SELECT TABLE_SCHEMA, TABLE_NAME, INDEX_NAME, SEQ_IN_INDEX, COLUMN_NAME, CARDINALITY, NULLABLE FROM information_schema.statistics WHERE index_type LIKE 'FULLTEXT%' ORDER BY TABLE_SCHEMA, TABLE_NAME
It is possible to method to set foot_min_word_length for just one database?