Re: [PHP-DB] MySQL full text search

2003-07-18 Thread Doug Thompson
Full text searches only work against fulltext indexes. http://www.mysql.com/doc/en/Fulltext_Search.html This isn't a PHP issue. Doug On Fri, 18 Jul 2003 09:42:17 +0200, Angelo Zanetti wrote: >Hi > >I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract >fields ha

[PHP-DB] MySQL full text search

2003-07-18 Thread Angelo Zanetti
Hi I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract fields have been fulltext indexes like this: ALTER TABLE biblio ADD FULLTEXT (title,abstract); that worked fine, however my problem is whenever I want to do a select statement only comparing 1 of the columns