Peter Gulutzan, author of SQL Performance Tuning, writes in The Full-Text Stuff That We Didn’t Put In The Manual about the particulars of word boundaries, index structure, boolean searching, exact phrase searching, and stopwords, as well as offering a few articles for further reading (Ian Gilfillan’s “Using Fulltext Index in MySQL”, Sergei Golubchik’s “MySQL Fulltext Search”, Joe Stump’s “MySQL FULLTEXT Searching”). It’s one of a number of articles in the MySQL Tech Resources collection.

mysql, full text, keyword searching, full text index, mysql indexing, stopwords, Peter Gulutzan

Posted September 17, 2006 by Casey Bisson
Categories: Blink, Technology. Tags: full text, full text index, keyword searching, mysql, mysql indexing, Peter Gulutzan, stopwords.

2 Comments

Comments RSS TrackBack Identifier URI

Leave a comment

Name (required)

Mail (will not be published) (required)

Website

 

User contributed tags for this post:

mysql fulltext performance (30) - fulltext mysql (27) - mysql fulltext slow (25) - mysql fulltext (21) - mysql full text search tips (20) - mysql full text index (17) - mysql fulltext stopwords (16) - mysql fulltext tips (16) - mysql fulltext tuning (14) - mysql (12) - mysql fulltext search tips (12) - mysql full text performance (11) - mysql full text catalog (9) - mysql full text tips (9) - mysql fulltext exact phrase (8) - mysql exact (7) - mysql fulltext numbers (7) - mysql fulltext index (7) - tips on 69 com (7) - mysql stoplist (7) - tagcloud fulltext (7) - mysql full text slow (7) - mysql fulltext google (6) - Full-Text Stopwords (6) - mysql fulltext index join (6) - fulltext slow mysql (6) - MySQL Search Tips (6) - mysql5 full text search (6) - mysql fulltext join (6) - mysql full text (6) - F (6) - MySQL Fulltext Keyword (5) - mysql5 fulltext (5) - mysql stop words (5) - fulltext stopwords (5) - CREATE FULLTEXT INDEX mysql (5) - golubchik mysql fulltext search (5) - mysql xml fulltext (5) - mysql fulltext search slow (5) - mysql slow fulltext (5) - MYSQL FULLTEXT XML (5) - mysql full text search performance (5) - mysql fulltext vs LIKE (5) - create full text index mysql (5) - exact search in mysql (5) - fulltext tips (4) - mysql Fulltext union (4) - mysql full text stopwords (4) - mysql stopwords (4) - mysql xml index full text search (4) - tuning mysql fulltext (4) - mysql exact phrase (4) - full text catalog mysql (4) - mysql fulltext exact PHRASE search (4) - exact search fulltext in mysql (4) - fulltext mysql5 (4) - mysql exact search (4) - mysql fulltext stop words (4) - php fulltext mysql (4) - mysql minimum full text performance (4) - fulltext index mysql (4) - MySQL Full-Text Search Rocks My World (4) - php fulltext (4) - time passing quote (3) - fulltext mysql 5 (3) - FULLTEXT MYSQL exact (3) - mysql full text index slow create (3) - mysql phrase (3) - mysql fulltext serach (3) - mysql fulltext good bad (3) - mysql min_word_length (3) - mysql 5 fulltext search (3) - mysql fulltext catalog (3) - performance mysql fulltext (3) - php mysql full text search (3) - mysql full text search exact phrase (3) - golubchik fulltext (3) - mysql5 fulltext performance (3) - mysql full text index slow (3) - mysql fulltext relevance (3) - MySql indexing Tips (3) - MYSQL Full Text Search Slow (3) - fulltext and mysql join (3) - php mysql fulltext (3) - mysql 5 fulltext (3) - mysql5 fulltext search (3) - mysql fulltext performance tuning (3) - tagcloud stopWords (3) - fulltext mysql tips (3) - fulltext mysql slow (3) - slow mysql full text search (3) - golubchik mysql fulltext search 2003 (3) - mysql Sergei Golubchik fulltext arabic (3) - full text search php mysql (2) - mysql fulltext arabic search (2) - mysql fulltext related word (2) - mysql fulltext query slow (2) - fulltext tag cloud (2) - mysql FULL TEXT SEARCH related videos (2) - web pages mysql fulltext stop list (2) - mysql full text search arabic (2) - mysql fulltext index list of tags (2) - golubchik mysql fulltext (2) - full text search tips mysql (2) - fulltext join mysql (2) - full text slow (2) - mysql fulltext search is slow tune (2) - full text mysql tips (2) - mysql fulltext searching tips (2) - stopwords php array (2) - mysql 5 vs 4 fulltext (2) - php mysql relevancy array full text (2) - full text mysql stopwords problems (2) - mysql stop words list (2) - mysql full text xml (2) - fulltext search join mysql where (2) - mysql full text search tuning (2) - tuning mysql full text (2) - keyword index mysql (2) - mysql arabic collection (2) - mysql fulltext keyword search (2) - arabic keyword search mysql (2) - mysql search index fulltext tag (2) - mysql tips (2) - mysql xml full text indexing (2) - ian gilfillan mysql fulltext (2) - fulltext index stopwords (2) - php stopwords (2) - fulltext tip (2) - fulltext index mysql5 (2) - php mysql stopwords (2) - fulltext in mysql (2) - FULLTEXT KEYWORD (2) - php fulltext search (2) - stoplist full text search mysql (2) - keyword search arabic mysql (2) - mysql fulltext stoplist (2) - mysql Full-Text Stopwords (2) - tag cloud fulltext mysql (2) - Sergei Golubchik mysql fulltext (2) - create fulltext index with MYSQL (2) - PHP and MySQL FULLTEXT (category), (2) - search php mysql fulltext index (2) - mysql full text index performance tips (2) - mysql create full text index (2) - mysql xml index (2) - mysql fulltext exact search (2) - fulltext mysql 6 (2) -