Full Text Search Against Help

[barkster]

I have a query like this where I'm trying to query all columns for any matching value but when I try and do my job_number field it will not find any results.

 

SELECT * FROM tasks WHERE MATCH (job_number,client_name)

AGAINST ('+097' IN BOOLEAN MODE)

 

taskid      job_number      client_name

1              21-097            Birch

2              22-884            Smith

 

When I run the query it will not find any tasks matching 097 but will find birch... any ideas.  All columns are set to text type

[QuickOldCar]

Try editing your ft_min_word_len=4 to a lower amount in /etc/my.cnf or /etc/mysql/my.cnf

 

After you change this you must repair the indexes on that table

 

REPAIR TABLE table_name QUICK;//edit to your table name