› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
aliipay
V2EX  ›  MySQL

mysql 全文索引查找不出来

  •  
  •   aliipay · Feb 25, 2020 · 5101 views
    This topic created in 2403 days ago, the information mentioned may be changed or developed.

    ngram_token_size 设置为 1

    CREATE TABLE articles (
          id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
          title VARCHAR(200),
          FULLTEXT (title) WITH PARSER ngram
        ) ENGINE=InnoDB CHARACTER SET utf8mb4;
    
    INSERT INTO articles (title) VALUES("a");
    INSERT INTO articles (title) VALUES("b");
    INSERT INTO articles (title) VALUES("f");
    
    

    搜索 a,返回空。为什么?

    select * FROM  articles  WHERE   MATCH (title) AGAINST ('+a' IN BOOLEAN MODE) ;
    
    

    ps, 把 a 改成 b 或者 f 则能正常返回。

    6 replies  •  2020-05-29 14:18:29 +08:00
    aliipay
        1
    aliipay  
    OP
       Mar 8, 2020 via Android
    up,这么久没人回
    kaffka
        2
    kaffka  
       Mar 13, 2020
    测试了下
    1238 - Variable 'ngram_token_size' is a read only variable, Time: 0.001000s
    默认是 2
    很好奇你是怎么设置的
    aliipay
        3
    aliipay  
    OP
       Mar 14, 2020
    @kaffka 直接修改配置文件然后重启 mysql
    sakaf
        4
    sakaf  
       May 29, 2020
    后面解决了吗,遇到同样的问题= =
    aliipay
        5
    aliipay  
    OP
       May 29, 2020
    @sakaf stopword 了解一下
    sakaf
        6
    sakaf  
       May 29, 2020
    谢谢大佬😂
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   2427 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 05:16 · PVG 13:16 · LAX 22:16 · JFK 01:16
    ♥ Do have faith in what you're doing.