Does RDS for MySQL 8.0 Support Full-Text Search?

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;