Hi James so what you are saying is that if I am not running mysql
4.0.10-gamma then the full text search wont work.
Strange because if I run the full text search on both full text indexed
fields I get the correct resultset, however I only want to do a full text
search on a column at a time, let me explain why:
because I have a title field and an abstract field which are both full text,
but i give the user the option of either searching for the title or the
abstract thats why I have them both full text indexed but would only like to
query 1 at a time.
So I am still not sure what to do.Could you please give me more advice.
thanx in Advance
Angelo
----- Original Message -----
From: "James Rodenkirch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 21, 2003 6:27 PM
Subject: [PHP] Re: need help with MySQL full text searching!!!!
> You need to use mysql 4.0.10-gamma for full text searching to work
>
> 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
> >
> > 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
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
