如何在MySql中进行重音敏感搜索

CREATE DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE my_table (
  id INT AUTO_INCREMENT PRIMARY KEY,
  content TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
);

ALTER TABLE my_table ADD FULLTEXT(content);

INSERT INTO my_table (content) VALUES ('Café 1'), ('Café 2'), ('Café 3');

SELECT * FROM my_table WHERE MATCH(content) AGAINST('+Café' IN BOOLEAN MODE);