Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003
    Location
    Sinapore
    Posts
    187

    Unanswered: Question on FULLTEXT...

    Hi,

    The following is found at (http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html)

    Code:
    CREATE TABLE articles (
        id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
        title VARCHAR(200),
        body TEXT,
        FULLTEXT (title,body)
    );
    My question is: What is the difference between specifying FULLTEXT individually on 'title' and 'body' and specifying it on the combined 'title' and 'body'. That is, between
    Code:
    FULLTEXT (title, body),
    
    and
    
    FULLTEXT (title),
    FULLTEXT (body),
    How does the difference affect the searches?

    Could someone enlighten me?

    Thanks in advance
    Last edited by pearl2; 05-13-04 at 03:05.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •