Showing entries 1 to 1
Displaying posts with tag: full-text index (reset)
Jan
17
2009
1/3 Implementing an AutoSuggest feature using MySQL fulltext indices
Posted by Richard Hirner on Sat 17 Jan 2009 18:45 UTC
Tags:

The MySQL full-text index Current MySQL versions provide a full-text index (FTI) which is generally used to index and search MyISAM (the default storage engine in MySQL) tables like this: SELECT id, content FROM documents WHERE MATCH(content) AGAINST ("tes*" IN BOOLEAN MODE) Internally, every indexed (text) column of a row is splitted into its words. [...]

Showing entries 1 to 1