あんま真面目に調べてないんですがメモ。 mysql> SELECT COUNT(*) FROM t1 WHERE MATCH(text_column) AGAINST('*D+ xxx' IN BOOLEAN MODE); +----------+ | COUNT(*) | +----------+ | 45402 | +----------+ 1 row in set (0.03 sec) MariaDB [d1]> SELECT COUNT(*) FROM t1 WHERE MATCH(text_column) AGAINST('*D+ xxx' IN BOOLEAN MODE); +----------+ | COUNT(*) | +----------+ | 45402 | +----------+ 1 row in set (0.06 sec) なんか倍くらい違う。 MariaD