Help Center > > FAQs> Database Usage> Does MySQL 8.0 Support Full-Text Search?

Does MySQL 8.0 Support Full-Text Search?

Updated at: Jun 09, 2021 GMT+08:00

Yes. MySQL 8.0 supports full-text search. The keyword is FULLTEXT. Run the following SQL statements to perform a test.

  • Creating a table
CREATE TABLE ARTICLE (
id int unsigned NOT NULL AUTO_INCREMENT, 
title varchar(200) DEFAULT NULL, 
Content text,
PRIMARY KEY (id), 
FULLTEXT KEY title (title,content),
FULLTEXT KEY fulltext_article (title,content)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  • Creating an index
    ALTER TABLE ARTICLE ADD FULLTEXT INDEX fulltext_article (title,content);
  • Querying an index
    SHOW INDEX FROM ARTICLE;

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel