Already Logged! sorry! search engine... wierd April 11, 2010 06:15AM |
Registered: 14 years ago Posts: 54 |
Re: Already Logged! sorry! search engine... wierd April 11, 2010 07:51AM |
Admin Registered: 17 years ago Posts: 1,791 |
Re: Already Logged! sorry! search engine... wierd April 11, 2010 08:04AM |
Admin Registered: 17 years ago Posts: 7,879 |
Re: Already Logged! sorry! search engine... wierd April 11, 2010 07:19PM |
Registered: 14 years ago Posts: 54 |
Re: Already Logged! sorry! search engine... wierd April 13, 2010 07:19AM |
Registered: 14 years ago Posts: 1,092 |
Quote
Change the ft_min_word_len setting. You can find what the server is using by running:
SHOW VARIABLES LIKE 'ft%';
Then you'll have to rebuild the indexes on the tables that have FULLTEXT indices, because the server I'm using had several databases I needed a quick way to identify which tables these were.
SELECT DISTINCT TABLE_SCHEMA,
TABLE_NAME
FROM COLUMNS
WERE COLUMN_KEY = 'MUL'