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 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. 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'? 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. Link to comment https://forums.phpfreaks.com/topic/60417-table-alter/#findComment-300614 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.