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;
```

Parent topic: Database Usage

Предыдущая статья

Does the OPTIMIZE TABLE Operation Lock Tables on an RDS DB Instance?

Следующая статья

How Do I Use the mysqlbinlog Tool?

Была ли эта статья полезна?

Поддержка Юридические документы