Re: FULLTEXT: It worked?? Why?
| From: | Jason Wong | Date: | Mon, 25 Nov 2002 03:45:53 +0000 |
| Subject: | Re: FULLTEXT: It worked?? Why? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-125869@lists.php.net to get a copy of this message | ||
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
*/