FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
Home / Indexes / Full Text Indexes / Question No: 183

What are full-text restrictions in MySQL?

I want to use MySQL fulltext feature but I am not much expert in MySQL database. Can MySQL allow to perform full-text search with all table engines or are there any restrictions for this feature?

Answer No: 183

Full-text search is one of the most useful features provided by MySQL.  However, there are some restrictions to perform full-text searches that MySQ follows:

  • Full-text searches are supported for MyISAM tables only. 
  • As of MySQL 4.1.1, full-text searches can be used with most multi-byte character sets. The exception is that for Unicode, the utf8 character set can be used, but not the ucs2 character set. However, although FULLTEXT indexes on ucs2 columns   cannot be used, you can perform IN BOOLEAN MODE   searches on a ucs2 column that has no such index. 
  • Ideographic languages such as Chinese and Japanese do not have word  delimiters. Therefore, the FULLTEXT parser cannot determine where words begin and end in these and other   such languages
  • As of MySQL 4.1, the use of multiple character sets within a single table is   supported. However, all columns in a FULLTEXT index   must use the same character set and collation. 
  • The MATCH() column list must match exactly the column list in some FULLTEXT index definition for the table,   unless this MATCH() is IN BOOLEAN MODE.   Boolean-mode searches can be done on non-indexed columns, although they are   likely to be slow. 
  • The argument to AGAINST() must be a constant string.

Related MySQL FAQs to the Above FAQ

Main-features-and-basic-information-about-full-text-search Main features and basic information about full-text search

On-what-data-types-fulltext-index-can-be-created On what data types fulltext index can be created?

How-to-create-full-text-index-in-MySQL How to create full-text index in MySQL?

How-to-create-multi-columns-full-text-index-in-MySQL How to create multi columns full-text index in MySQL?

What-are-natural-language-and-boolean-and-query-expansion-full-text-searches What are natural language and boolean and query expansion full-text searches?

How-to-use-boolean-full-text-search-in-MySQL How to use boolean full-text search in MySQL?

How-to-use-full-text-searches-with-query-expansion-in-MySQL How to use full-text searches with query expansion in MySQL?

How-to-use-natural-language-full-text-search-in-MySQL How to use natural language full-text search in MySQL?

What-are-stopwords-in-MySQL What are stopwords in MySQL?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: | | | |

© 2021
All rights reserved.