adam84 Posted July 17, 2007 Share Posted July 17, 2007 I am trying to add the FULLTEXT constraint on a column in my table, but i keep getting an error? Any ideas? ALTER TABLE products FULLTEXT(productDescription); Error Message: Can't find FULLTEXT index matching the column list Quote Link to comment https://forums.phpfreaks.com/topic/60417-table-alter/ Share on other sites More sharing options...
fenway Posted July 17, 2007 Share Posted July 17, 2007 Check the syntax again. Quote Link to comment https://forums.phpfreaks.com/topic/60417-table-alter/#findComment-300543 Share on other sites More sharing options...
adam84 Posted July 17, 2007 Author Share Posted July 17, 2007 The column 'productDescription' was created as a 'longtext', can FULLTEXT be used on a 'longtext'? Quote Link to comment https://forums.phpfreaks.com/topic/60417-table-alter/#findComment-300556 Share on other sites More sharing options...
fenway Posted July 17, 2007 Share Posted July 17, 2007 Shouldn't be an issue... but I don't see ADD INDEX anywhere. Quote Link to comment https://forums.phpfreaks.com/topic/60417-table-alter/#findComment-300614 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.