Re: 分かち書きとN-gramインデックスを両方一緒に使える？ (Senna-dev 315) - senna

$B$&$?$@$G$9(B

MySQL$B$G(Bcreate fulltext index$B9=J8$G!"(BSenna$B$N%$%s%G%C%/%9:F:n ＠ .$O(B
$B2DG=$G$7$g$&$+!)(B

$B$?$H$($P(B--without-mecab$B$rIU$1$?(BSenna$B$rAH$_9~$s$@(BMySQL$B$G(B
$B%F!<%V%k$KBP$7(Bcreate fulltext index$B$7$?$H$-!"(B
$B:n ＠ .$5$l$k%$%s%G%C%/%9$O(BNgram$B$G$7$g$&$+!)(B
($B$3$A$i$G;n$7$?$i(Bselect$B;~(B0$B7o$7$+JV$i$J$/$J$j$^$7$?(B)

alter table table_name add fulltext using ngram (column_name);
$B$@$H!"(BNgram$B%$%s%G%C%/%9$N:F:n ＠ .$,$G$-$k$h$&$G$9$,(B
(Ngram)$B%$%s%G%C%/%9$N:F:n ＠ .$dDI2C:n ＠ .$O$3$N=q<0$G9T$C$F$bJ?5$$G$7$g$&$+!)(B

$B$h$m$7$/$*4j$$$7$^$9(B

On Tue, 12 Sep 2006 11:09:57 +0900
Tasuku SUENAGA <a****@razil*****> wrote:

 |$BKv1J$G$9!#(B
 |
 |> $B!Z<ALd![(B
 |>     $B%$%s%G%C%/%9$N:n ＠ .$r(B
 |>         $B-!J,$+$A=q$-(B
 |>         $B-"(BN-gram
 |>     $B$NN>J}$G9T$$$?$$$N$G$9$,!"=PMh$^$9$G$7$g$&$+!)(B
 |
 |$B0J2<$N$h$&$K$7$F2DG=$G$9!#(B
 |$B!&(B./configure$B$N%*%W%7%g%s$G(B--without-mecab$B$rIU$1!V$J$$!W(B
 |N-gram$B%$%s%G%C%/%9$N>l9g(B
 |$B!&(BFULLTEXT INDEX$B:n ＠ .;~$K(BNGRAM$B%*%W%7%g%s$r$D$1$k(B
 |$BDL>o$N(BSenna$B%$%s%G%C%/%9$N>l9g(B
 |$B!&(BFULLTEXT INDEX$B:n ＠ .;~$K(BNGRAM$B%*%W%7%g%s$r$D$1$J$$(B
 |
 |$B%$%s%G%C%/%9:n ＠ .$N%*%W%7%g%s$K$D$$$F$O0J2<$r;2>H$7$F$/$@$5$$!#(B
 |http://qwik.jp/senna/mysql_binding.html
 |
 |$B$A$J$_$K!"%$%s%G%C%/%9:n ＠ .;~$K%$%s%G%C%/%9%?%$%W$r(B
 |$B ＠ Z$jBX$($i$l$k$h$&$K$J$C$?$N$O!"(BGREE$B$5$^$K$h$k ＠ .2L$G$9!*(B
 |http://labs.gree.jp/Top/OpenSource/MySQL_Senna.html

---
Katsuya Utada <utada****@themi*****>

senna

[Senna-dev 315] Re: 分かち書きとN-gramインデックスを両方一緒に使える？