Re: FULLTEXT Query

create fulltext index search on ccl_main(au); -J On Tue, 18 Jun 2002 10:13:33 +1200, John Taylor-Johnston wrote: > 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'; -- Jason Morehouse (jm@netconcepts.com) Netconcepts LTD - Auckland, New Zealand * Linux: Because rebooting is for adding hardware.