Jason, Sorry Jason ... No offense, I learned my MySQL here :) It's for a PHP script, after all. Besides unless I want to fill my mail box quota in 3 minutes ... Here I can post using a news-reader. Can anyone out there help :) please? John
> On Monday 25 November 2002 10:59, John Taylor-Johnston wrote: > > 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'; > > This has nowt to do with PHP, please ask on the MySQL list. > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > Passionate hatred can give meaning and purpose to an empty life. > -- Eric Hoffer > */ -- John Taylor-Johnston ----------------------------------------------------------------------------- "If it's not open-source, it's Murphy's Law." ' ' ' Collège de Sherbrooke: ô¿ô http://www.collegesherbrooke.qc.ca/languesmodernes/ - Université de Sherbrooke: http://compcanlit.ca/ 819-569-2064 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php