FULLTEXT: It worked?? Why?
| From: | John Taylor-Johnston | Date: | Mon, 25 Nov 2002 02:59:29 +0000 |
| Subject: | FULLTEXT: It worked?? Why? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-125862@lists.php.net to get a copy of this message | ||
MySQL4.0.1 Question. HTOK
FULLTEXT index confusion.
Why does my SQL work?
SELECT YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC,AUS
FROM ccl_main
WHERE MATCH (AUS)
AGAINST ('+margaret +atwood' IN BOOLEAN MODE)
ORDER BY id desc
AUS is not part of my FULLTEXT Index. So why does it work? How does FULLTEXT work then???
CREATE TABLE ccl_main (
id int(10) unsigned NOT NULL auto_increment,
...
PRIMARY KEY (id),
FULLTEXT KEY CCL2002 (YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC)
) TYPE=MyISAM COMMENT='CCL Bibliography - Bibliographie ECC';