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 [...]
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.
I’m going out on a limb to say MySQL’s full-text indexing and searching features are underused. They appeared in MySQL 3.23.23 (most people are using 4.x, and 5 is in development), but it’s been news to most of the people I know.
Here’s the deal, the MATCH() function can search a full-text index for a string [...]
Posted September 6, 2005 by Casey Bisson
Categories: Technology. Tags: boolean search, boolean searches, boolean searching, database, db, docs, documentation, full text, full text index, full text search, full text searching, fulltext, fulltext search, keywords, match(), mysql, rank, relevance, relevance rank, relevance ranked, relevance ranking, search, search full text. 8 Comments.
