mysql实现中文全文检索

CREATE TABLE articles (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255),
    content TEXT,
    FULLTEXT (title, content)
) ENGINE=InnoDB;

INSERT INTO articles (title, content) VALUES
('MySQL 中文全文检索', '本文介绍了如何在 MySQL 中实现中文全文检索。'),
('全文检索的优势', '全文检索能够快速、准确地定位到包含特定关键词的记录。');

import mysql.connector
from ik_analyzer import IKSegmentation

# 连接 MySQL 数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)
cursor = db.cursor()

# 查询关键词
query_keyword = "MySQL 中文全文检索"

# 使用 IK Analyzer 进行分词
ik_segmenter = IKSegmentation()
words = ik_segmenter.segment(query_keyword)

# 构建 SQL 查询语句
sql = f"SELECT * FROM articles WHERE MATCH(title, content) AGAINST('{'+ ' '.join(words) +'}' IN NATURAL LANGUAGE MODE);"

# 执行查询
cursor.execute(sql)
results = cursor.fetchall()

# 输出结果
for result in results:
    print(result)

# 关闭连接
cursor.close()
db.close()