<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    Chapter 6:  MySQL Language Reference 489 apple banana nd rows that contain at least one of these words. +apple +juice ...  both words. +apple macintosh ...  word \apple", but rank it higher if it also contain \macintosh". +apple -macintosh ...  word \apple" but not \macintosh". +apple +(>pie <strudel) ...  \apple" and \pie", or \apple" and \strudel" (in any order), but rank \apple pie" higher than \apple strudel". apple* ...  \apple", \apples", \applesauce", and \applet". "some words" ...  \some words of wisdom", but not \some noise words". 6.8.1  Full-text Restrictions    All parameters to the  MATCH()  function must be columns from the same table that is part of the same FULLTEXT index, unless the MATCH() is IN BOOLEAN MODE.    The MATCH() column list must exactly match the column list in some FULLTEXT index de nition for the table, unless this MATCH() is IN BOOLEAN MODE.    The argument to AGAINST() must be a constant string. 6.8.2  Fine-tuning MySQL Full-text Search Unfortunately, full-text search has few user-tunable parameters yet, although adding some is  very  high  on  the  TODO.  If  you  have  a  MySQL  source  distribution  (see  Section  2.3 [Installing source], page 80), you can exert more control over full-text searching behaviour. Note that full-text search was carefully tuned for the best searching e ectiveness. Modifying the default behaviour will, in most cases, only make the search results worse.  Do not alter the MySQL sources unless you know what you are doing!    The minimum length of words to be indexed is de ned by the MySQL variable  ft_ min_word_len.  See Section 4.5.6.4 [SHOW VARIABLES], page 257.  Change it to the value you prefer, and rebuild your FULLTEXT indexes.  (This variable is only available from MySQL version 4.0.)    The stopword list is de ned in `myisam/ft_static.c' Modify it to your taste, recompile MySQL, and rebuild your FULLTEXT indexes.    The 50% threshold is determined by the particular weighting scheme chosen. To disable it, change the following line in `myisam/ftdefs.h': #define GWS_IN_USE GWS_PROB To:
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide