I think you need to make a second index that just consists of the one column
ALTER TABLE biblio ADD FULLTEXT (title)
if you want to search on just that one column.
---John Holmes...
----- Original Message -----
From: "Angelo Zanetti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 21, 2003 12:09 PM
Subject: [PHP] need help with MySQL full text searching!!!!
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
ps. sorry that this may be a bit off topic
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
