MySQL Forums
Forum List  »  PHP

Using SELECT WHERE and MATCH
Posted by: Ian Biner
Date: April 27, 2005 05:13AM

Hello,

I hope a smei-newbie can get a little help here... I seem to need information that's in between a basic tutorial and the complexity of the mySQL manual.

I'm trying to construct a query that searches for a string in a FULLTEXT index, but ONLY in specific records.

The query I've put together is as follows;

SELECT * FROM forumitems -> WHERE FOfrn = '$frrn' AND MATCH (FOhead, FOtext) AGAINST ('$search');

Is this correct, (it doesn't seem to be working), and what is the function of the "->" in the query?

Thanks
Ian

Options: ReplyQuote


Subject
Written By
Posted
Using SELECT WHERE and MATCH
April 27, 2005 05:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.