I'm obviously getting myself into more and more trouble with fulltext.. I have the following SQL statement; SELECT indexIdentity, webpageIdentity, content, MATCH (content) AGAINST ('gallery' ) as score FROM db_com_pacificmomentum.tbl_index where MATCH (content) AGAINST ('gallery' ); Which returns the following error: Can't find FULLTEXT index matching the column list While I know there is a fulltext index on the column, when I run SELECT indexIdentity, webpageIdentity, content, MATCH (content) AGAINST ('gallery' in boolean mode) as score FROM db_com_pacificmomentum.tbl_index where MATCH (content) AGAINST ('gallery' in boolean mode); It works fine. Kind regards,
Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development * Accept online Credit Card payments www.commerceengine.com.au <http://www.commerceengine.com.au/> * SMS Solutions, including developer API * Domain Registration, .COM for as low as fifteen dollars a year, .COM.AU for fifty dollars two years!