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 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 to inputted data ( in a Select statement):
>
>$result = mysql_query("SELECT * FROM Biblio WHERE MATCH (title) AGAINST
>('$searchString')");
>
>It gives me this error: Can't find FULLTEXT index matching the column list. It
>appears that i cant just compare a single fulltext indexed column if there are other
>fulltext indexed columns. When I try it with both columns then it works but I just
>want to compare 1 column. eg:
>$result = mysql_query("SELECT * FROM Biblio WHERE MATCH (title, abstract) AGAINST
>('$searchString')");
>
>So is there anyway that I can just compare 1 column with text entered? Do I have t
>make some sort of temporary table to do this? All the examples I have found show the
>select statement with 2 columns or if they use 1 coumn its because there is only 1
>column in their table.
>
>Any help would be appreciated!
>
>TIA
>
>Angelo
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
