Kouhei Sutou
kou****@clear*****
2012年 5月 30日 (水) 16:45:07 JST
$B?\F#$G$9!#(B In <71E00B89608D42FCB0D0C97050965480 @ winxp130> "[groonga-dev,00903] Re: $B99?7=hM};~$N(Bbinlog$B8m%G!<%?$N5-F~(B" on Sat, 26 May 2012 00:12:24 +0900, "nn2480" <nishi****@webre*****> wrote: > $B#2!K8!:w%-!<%o!<%I$G$N8!:wO3$l$NLdBj(B > $B8!:w$O!"(Bmecab ipadic$B$rMxMQ$7!!(Bin boolean mode$B$G8!:w$7$F$$$^$9$,!"(B > $B$?$H$($P!"%O%$%M$H8!:w8l$rF~$l$?>l9g!"(B > $B%O%$%M;m=8!"%O%$%M!&2sA[O?$J$I$O!"8!:w$5$l$k$N$G$9$,!"$J$<$+(B > $B%O%$%M8&5f$O8!:w$5$l$^$;$s!"!"(B > > $B$3$N860x$,$h$/$o$+$i$J$$$N$G$9$,!"(B > $B-!(Bin boolean mode$B$G!"%O%$%M$HF~$l$?>l9g!"%O%$%M8&5f$b8!:w$5$;$k(B > $B$K$O!"$I$&$7$?$i$h$$$N$G$7$g$&$+!)(B $B1sF#$5$s$+$i$N%3%a%s%H$K$"$k$h$&$K!"(BMeCab$B$N<-=q$r6/2=$9$k$+(B N-gram$B$J%H!<%/%J%$%6!<$r;HMQ$7$^$9!#(B groonga$B$G$O%H!<%/%J%$%6!<$N0c$&J#?t$N%$%s%G%C%/%9$rF1;~$K;H$C(B $B$FA4J88!:w$r$9$k$3$H$,$G$-$^$9!#$=$N5!G=$r;H$&$H(BTokenMecab$B$G(B $B%^%C%A$7$?>l9g$O%R%C%H%9%3%"$rBg$-$a$K$7$F!"(BTokenBigram$B$K%^%C(B $B%A$7$?>l9g$O%R%C%H%9%3%"$r>.$5$a$K$9$k!"$J$I$7$F!"(BMeCab$B$G%^%C(B $B%A$7$J$$>l9g$G$b$G$-$k$@$18!:wO3$l$r>/$J$/=PMh$^$9!#(B $B$?$@!"(BMySQL$B$K$OA4J88!:w;~$K;HMQ$9$k%$%s%G%C%/%9$r;XDj$9$k9=(B $BJ8$,$J$$$N$G!"",$,$G$-$J$$$N$G$9!#!#!#(B $B%*!<%P!<%X%C%I$,$"$C$F$b5vMFHO0OFb$G$"$l$P!"(B CREATE TABLE ... ( body TEXT, body_bigram TEXT, FULLTEXT INDEX body_index_mecab (body) COMMENT 'parser "TokenMecab"', FULLTEXT INDEX body_index_bigram (body) COMMENT 'parser "TokenBigram"' ) ENGINE=mroonga ...; $B$H$$$&$h$&$K$7$F!"(Bbody$B$K$b(Bbody_bigram$B$K$bF1$8%G!<%?$rF~$l$l$P!"(B SELECT MATCH (body) AGAINST ("$B%O%$%M(B" IN BOOLEAN MODE) * 100 + MATCH (body_bigram) AGAINST ("$B%O%$%M(B" IN BOOLEAN MODE) AS score table WHERE MATCH (body) AGAINST ("$B%O%$%M(B" IN BOOLEAN MODE) AND MATCH (body_bigram) AGAINST ("$B%O%$%M(B" IN BOOLEAN MODE); $B$H$$$&$h$&$J$3$H$b$G$-$k$+$J$!$H;W$$$^$7$?$,!"$@$$$V6/0z$G$9$M!#!#!#(B > $B-"(Bmecab$B$N<-=q$r!"8=:_$N(Bipadic$B$+$i!"(Bnaist-jdic,unidic$B$J$I$KJQ99$9$l$P!"(B > $B$3$NLdBj$O2r7h$9$k$N$G$7$g$&$+!)(B MeCab$B$,$I$N$h$&$K%H!<%/%J%$%:$9$k$+$O0J2<$N%3%^%s%I$G3NG'$G(B $B$-$^$9!#(B % echo "$B3N$+$a$?$$J8=q(B" | mecab $BNc$($P!":#2s$NNc$G$G$F$-$?$b$N$O0J2<$N$h$&$K$J$j$^$9!#(B $B!J(BNAIST-jdic$B$r;H$C$?>l9g!K(B % echo $B%O%$%M(B | mecab $B%O%$(B $BL>;l(B,$B0lHL(B,*,*,*,*,$B%O%$(B,$B%O%$(B,$B%O%$(B,, $B%M(B $B=u;l(B,$B=*=u;l(B,*,*,*,*,$B%M(B,$B%M(B,$B%M(B,, EOS % echo $B%O%$%M;m=8(B | mecab $B%O%$%M(B $BL>;l(B,$B0lHL(B,*,*,*,*,* $B;m=8(B $BL>;l(B,$B0lHL(B,*,*,*,*,$B;m=8(B,$B%7%7%e%&(B,$B%7%7%e!<(B,, EOS % echo $B%O%$%M!&2sA[O?(B | mecab $B%O%$(B $BL>;l(B,$B0lHL(B,*,*,*,*,$B%O%$(B,$B%O%$(B,$B%O%$(B,, $B%M(B $B=u;l(B,$B=*=u;l(B,*,*,*,*,$B%M(B,$B%M(B,$B%M(B,, $B!&(B $B5-9f(B,$B0lHL(B,*,*,*,*,$B!&(B,$B!&(B,$B!&(B,, $B2sA[(B $BL>;l(B,$B%5JQ@\B3(B,*,*,*,*,$B2sA[(B,$B%+%$%=%&(B,$B%+%$%=!<(B,, $BO?(B $BL>;l(B,$B@\Hx(B,$B0lHL(B,*,*,*,$BO?(B,$B%m%/(B,$B%m%/(B,, EOS % echo $B%O%$%M8&5f(B | mecab $B%O%$%M(B $BL>;l(B,$B0lHL(B,*,*,*,*,* $B8&5f(B $BL>;l(B,$B%5JQ@\B3(B,*,*,*,*,$B8&5f(B,$B%1%s%-%e%&(B,$B%1%s%-%e!<(B,, EOS $B$^$:!"8!:w%/%(%j!<$N!V%O%$%M!W$,!V%O%$!W$H!V%M!W$GJ,$+$l$F$$(B $B$k$N$G!"8!:wBP>]$NJ}$b!V%O%$!W$H!V%M!W$KJ,$+$l$F$$$kI,MW$,$"(B $B$j$^$9!#$h$C$F!"$3$N>l9g$G$O!V%O%$%M!&2sA[O?!W$7$+%^%C%A$7$^(B $B$;$s!#(B $B<-=q$rJQ$($?$j!"<+J,$GJT=8$7$?>l9g$O$3$N$h$&$K5sF0$rM=A[$9$k(B $B$3$H$,$G$-$^$9!#!J(Bgroonga$B%l%Y%k$GA0=hM}$r$7$F$+$i(BMeCab$B$KJ8=q(B $B$rEO$9%1!<%9$b$"$k$N$G!">l9g$K$h$C$F$O(Bmecab$B%3%^%s%I$N7k2L$H(B $B0lCW$7$J$$$3$H$b$"$j$^$9!#!K(B -- $B?\F#(B $B8yJ?(B <kou****@clear*****> $B3t<02q<R%/%j%"%3!<%I(B <http://www.clear-code.com/> (03-6231-7270) groonga$B%5%]!<%H(B: http://groonga.org/ja/support/ $B%W%m%0%i%_%s%0$,9%$-$J%=%U%H%&%'%"3+H/<T$rJg=8Cf(B: http://www.clear-code.com/recruitment/