MySQL Forums
Forum List  »  Full-Text Search

Match Error When Specifying 2 or More Columns
Posted by: john d
Date: May 03, 2010 04:21PM

Having problem inserting two or more columns into my Match..Against statement on my Hosting environment. On my test server the query runs fine.
ie ...WHERE MATCH(Title,Description) AGAINST('term');

Error (something about no Fulltext index found on specified column list) Ive checked the table structure and there already in place on my columns that are used by the query (Title, Description)

If I try it one at a time(WHERE MATCH(Title)...) they return fine. Im thinking that its either a MySQL version problem on my hosting environment or a restriction that they have in place. Need you to confirm this if youve also had the same problem with a hosting company.

Options: ReplyQuote

Written By
Match Error When Specifying 2 or More Columns
May 03, 2010 04:21PM

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.