Categorized | News

Getting Started With MySQL’s Full-Text Search Capabilities

Posted on 31 August 2002 by Demian Turner

from DevArticles.com
Advantages of full-text searches:

  • Full-text searching is ideal for extremely large databases that contain thousands or even millions of rows. Computations are performed faster and rows can be ranked based on search relevance, which is returned as a decimal number by MySQL.
  • Noise words and any words that are 3 characters or less in length such as the, and, etc are removed from the search query. This means that more accurate results are returned. If you searched for "as the people", then the noise words "the" and "as" will automatically be removed from your query.
  • In addition to simple searches, full-text searches can also be performed in Boolean mode. Boolean mode allows searches based on and/or criteria, such as "+person +Mitchell", which would only return all records that contained the words person AND Mitchell. We will look at Boolean searches later in this article.
  • The query is case-insensitive, meaning that "cat" is ranked the same as "Cat", "CAT" and "cAT".
Bookmark and Share

1 Comments For This Post

  1. Anonymous Says:

    Squirrel Mail does not announce the size of each message coming in. I need to know that info because I delete most anonymous mail anyway before opening it, especially if it is of a certain size.

Leave a Reply

Categories

Books

Demian Turner's currently-reading book recommendations, reviews, favorite quotes, book clubs, book trivia, book lists

Facebook