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.
Subject
Views
Written By
Posted
Match Error When Specifying 2 or More Columns
4174
May 03, 2010 04:21PM
2093
May 05, 2010 11:57PM
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.