6.8.1 Full-text Restrictions

• Full-text searches are supported for MyISAM tables only.
• Full-text searches can be used with single-byte character sets only.
• All parameters to the MATCH() function must be columns from the same table that is part of the same FULLTEXT index, unless the MATCH() is IN BOOLEAN MODE.
• The MATCH() column list must exactly match the column list in some FULLTEXT index definition for the table, unless this MATCH() is IN BOOLEAN MODE.
• The argument to AGAINST() must be a constant string.

User Comments

Add your own comment.