SELECT * FROM test_app_article WHERE MATCH(content) AGAINST('Hello');

/*CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
body TEXT
) ENGINE=InnoDB CHARACTER SET utf8mb4;

ALTER TABLE articles ADD FULLTEXT INDEX ft_index (title,body) WITH PARSER ngram;

CREATE fulltext INDEX index_name ON table_name(colum_name) WITH PARSER ngram;

INSERT INTO articles (title,body) VALUES
('数据库管理','在本教程中我将向你HelloWorld展示如何管理数据库'),
('数据库应用开发','学习开发数据库应用程序');
COMMIT;
ALTER TABLE test_app_article ADD FULLTEXT INDEX ft_index (title,content) WITH PARSER ngram;
commit;

INSERT into test_app_article (title,content) values ("AutoSlugField中国人民大学生my-sql","AutoSlugField中国人民大学生my-sqlAutoSlugField中国人民大学生my-sql");

SELECT * FROM articles WHERE MATCH(body,title) AGAINST('数据' IN BOOLEAN MODE);

*/

INSERT INTO test_app_article (title,content) VALUES
('数据库管理','在本教程中我将向你HelloWorld展示如何管理数据库'),
('数据库应用开发','学习开发数据库应用程序');
commit;