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
dBforums
>
Question on FULLTEXT...
05-13-04, 01:36
Linear Mode
