MySQL Full-Text Search 4 MySQL

4. 풀텍스트 스탑워드

중지 단어 목록은 서버 문자 집합과 데이터 정렬 (character_set_server 및 collation_server 시스템 변수 값)을 사용하여 전체 텍스트 쿼리를로드하고 검색합니다. 전체 텍스트 인덱싱 또는 검색에 사용되는 중지 단어 파일이나 열이 character_set_server 또는 collation_server와 다른 문자 집합 또는 데이터 정렬을 갖는 경우 중지 단어 조회에 대해 잘못된 결과가 발생할 수 있습니다.

중지 단어 조회의 대소 문자 구분은 서버 데이터 정렬에 따라 다릅니다. 예를 들어, 조회는 latin1_swedish_ci 인 경우 조회에서 대소 문자를 구분하지 않지만 조회가 latin1_general_cs 또는 latin1_bin 인 경우 조회는 대소 문자를 구분합니다.

stopword 파일은 character_set_server가 ucs2, utf16 또는 utf32 인 경우 latin1을 사용하여로드되고 검색됩니다.

다음 목록은 기본 전체 텍스트 중지 단어를 보여줍니다. MySQL 소스 배포판에서는 storage / myisam / ft_static.c 파일에서이 목록을 찾을 수 있습니다.

a's able about above accordingaccordingly across actually after afterwardsagain against ain't all allowallows almost alone along alreadyalso although always am amongamongst an and another anyanybody anyhow anyone anything anywayanyways anywhere apart appear appreciateappropriate are aren't around asaside ask asking associated atavailable away awfully be becamebecause become becomes becoming beenbefore beforehand behind being believebelow beside besides best betterbetween beyond both brief butby c'mon c's came cancan't cannot cant cause causescertain certainly changes clearly cocom come comes concerning consequentlyconsider considering contain containing containscorresponding could couldn't course currentlydefinitely described despite did didn'tdifferent do does doesn't doingdon't done down downwards duringeach edu eg eight eitherelse elsewhere enough entirely especiallyet etc even ever everyeverybody everyone everything everywhere exexactly example except far fewfifth first five followed followingfollows for former formerly forthfour from further furthermore getgets getting given gives gogoes going gone got gottengreetings had hadn't happens hardlyhas hasn't have haven't havinghe he's hello help henceher here here's hereafter herebyherein hereupon hers herself hihim himself his hither hopefullyhow howbeit however i'd i'lli'm i've ie if ignoredimmediate in inasmuch inc indeedindicate indicated indicates inner insofarinstead into inward is isn'tit it'd it'll it's itsitself just keep keeps keptknow known knows last latelylater latter latterly least lesslest let let's like likedlikely little look looking looksltd mainly many may maybeme mean meanwhile merely mightmore moreover most mostly muchmust my myself name namelynd near nearly necessary needneeds neither never nevertheless newnext nine no nobody nonnone noone nor normally notnothing novel now nowhere obviouslyof off often oh okokay old on once oneones only onto or otherothers otherwise ought our oursourselves out outside over overallown particular particularly per perhapsplaced please plus possible presumablyprobably provides que quite qvrather rd re really reasonablyregarding regardless regards relatively respectivelyright said same saw saysaying says second secondly seeseeing seem seemed seeming seemsseen self selves sensible sentserious seriously seven several shallshe should shouldn't since sixso some somebody somehow someonesomething sometime sometimes somewhat somewheresoon sorry specified specify specifyingstill sub such sup suret's take taken tell tends th than thank thanks thanxthat that's thats the theirtheirs them themselves then thencethere there's thereafter thereby thereforetherein theres thereupon these theythey'd they'll they're they've thinkthird this thorough thoroughly thosethough three through throughout thruthus to together too tooktoward towards tried tries trulytry trying twice two ununder unfortunately unless unlikely untilunto up upon us useused useful uses using usuallyvalue various very via vizvs want wants was wasn'tway we we'd we'll we'rewe've welcome well went wereweren't what what's whatever whenwhence whenever where where's whereafterwhereas whereby wherein whereupon whereverwhether which while whither whowho's whoever whole whom whosewhy will willing wish withwithin without won't wonder wouldwouldn't yes yet you you'dyou'll you're you've your yoursyourself yourselves zero


댓글 입력 영역