FULLTEXT Query
| From: | John Taylor-Johnston | Date: | Mon, 17 Jun 2002 22:13:33 +0000 |
| Subject: | FULLTEXT Query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-102613@lists.php.net to get a copy of this message | ||
Can anyone couldn't recommend a MySQL newsgroup please? Begging your pardon for a MySQL answer
here :o) I have tried: mysql@lists.mysql.com but it is
emailing and blew my quota in very little time.
I'm using this:
mysql_query("SELECT * FROM $table WHERE MATCH (AU) AGAINST ('.$au.') order by AU
desc");
And I get this error:
Can't find FULLTEXT index matching the column list
How do I modify my table to make a full text search on Au & AUS ? Right now my structure looks
like this:
CREATE TABLE ccl_main (
id int(6) NOT NULL auto_increment,
RNum int(11) NOT NULL default '0',
AU text NOT NULL,
ST longtext NOT NULL,
BT longtext NOT NULL,
KW longtext NOT NULL,
AUS text NOT NULL,
GEO text NOT NULL,
PRIMARY KEY (id),
FULLTEXT KEY AU (AU,AUS)
) TYPE=MyISAM COMMENT='CCL Bibliography - Bibliographie ECC';