MySQL full text search for words with three or less letters

by

This section of the manual might interest you : 11.8.6. Fine-Tuning MySQL Full-Text Search (quoting a portion of it) :

The minimum and maximum lengths of
words to be indexed are defined by the
ft_min_word_len and ft_max_word_len
system variables. The
default minimum value is four
characters; the default maximum is
version dependent. If you change
either value, you must rebuild your
FULLTEXT indexes.
For example, if you
want three-character words to be
searchable, you can set the
ft_min_word_len variable by putting
the following lines in an option file:

[mysqld]
ft_min_word_len=3

Then you must restart the server and
rebuild your FULLTEXT indexes.

(You should read that page, for more informations I didn’t copy-paste 😉 )

More Related Contents:

  1. Fulltext Search with InnoDB
  2. How to search multiple columns in MySQL?
  3. Any way to achieve fulltext-like search on InnoDB
  4. MySQL: Alternatives to ORDER BY RAND()
  5. MySQL LIKE IN()?
  6. Auto Increment after delete in MySQL
  7. Unioning two tables with different number of columns
  8. NULL in MySQL (Performance & Storage)
  9. In MySQL queries, why use join instead of where?
  10. MySQL function to find the number of working days between two dates
  11. MySQL Trigger to prevent INSERT under certain conditions
  12. Importance of varchar length in MySQL table
  13. Stored Procedure with optional “WHERE” parameters
  14. SQLite – ORDER BY RAND()
  15. MySQL – Selecting data from multiple tables all with same structure but different data
  16. Can a stored procedure/function return a table?
  17. Adding a new SQL column with a default value
  18. Selecting all corresponding fields using MAX and GROUP BY
  19. Multiple Ranks in one table
  20. Create date from day, month, year fields in MySQL
  21. The difference between ‘AND’ and ‘&&’ in SQL
  22. Can I use a MySQL database with an App Engine application
  23. How can I make an average of dates in MySQL?
  24. What is the best way to generate ranks in MYSQL?
  25. What does collation mean?
  26. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  27. COUNT(id) vs. COUNT(*) in MySQL
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment