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';
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
