{"id":772,"date":"2022-07-27T04:58:09","date_gmt":"2022-07-27T04:58:09","guid":{"rendered":"http:\/\/happily70.dothome.co.kr\/?p=772"},"modified":"2022-07-30T09:30:37","modified_gmt":"2022-07-30T09:30:37","slug":"772","status":"publish","type":"post","link":"https:\/\/happily70.dothome.co.kr\/?p=772","title":{"rendered":"FullText \uac80\uc0c9"},"content":{"rendered":"\n<p>LIKE \uc5f0\uc0b0\uc744 \ud1b5\ud574 \uac80\uc0c9\uc744 \ud558\uac8c \ub418\uba74 \uc778\ub371\uc2a4\ub97c \ud1b5\ud55c \uac80\uc0c9\uc774 \uc5b4\ub824\uc6b4\ub370 \uc774\ub7f4 \ub54c \uace0\ub824\ud574\ubcfc \uc218 \uc788\ub294 \uac83\uc774 <strong>Full-Text \uac80\uc0c9<\/strong>\uc73c\ub85cFullText \uac80\uc0c9\uc740 \ub2e8\uc5b4 \ub610\ub294 \uad6c\ubb38\uc5d0 \ub300\ud55c \uac80\uc0c9\uc744 \uc758\ubbf8.<\/p>\n\n\n\n<p>MyISAM\uc740&nbsp;MySQL&nbsp;5.5 \ubc84\uc804 \uc774\uc0c1\ubd80\ud130, innoDB\ub294&nbsp;MySQL&nbsp;5.6 \ubc84\uc804 \ubd80\ud130&nbsp;\uc9c0\uc6d0.<\/p>\n\n\n\n<h1 class=\"wp-block-heading\">\uc2e4\ud589 \ubc29\ubc95<\/h1>\n\n\n\n<h3 class=\"wp-block-heading\">MATCH &#8230; AGAINST<\/h3>\n\n\n\n<p>\uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc740 <strong>MATCH AGAINST<\/strong> \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc218\ud589.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MATCH (col1,col2,...) AGAINST (expr &#91;search_modifier])<\/code><\/pre>\n\n\n\n<p><strong>MATCH<\/strong>\ub294 \uc27c\ud45c\ub85c \uad6c\ubd84\ub418\uba70 <strong>\uac80\uc0c9\ud560 \uc5f4<\/strong>\uc744 \uc9c0\uc815\ud558\uba70, <strong>AGAINST<\/strong>\ub294 <strong>\uac80\uc0c9\ud560 \ubb38\uc790\uc5f4<\/strong>\uacfc \uc218\ud589\ud560 <strong>\uac80\uc0c9 \ubc29\uc2dd<\/strong>\uc744 \uc9c0\uc815<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\uac80\uc0c9 \uc720\ud615 :\n{\n       IN NATURAL LANGUAGE MODE\n     | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION\n     | IN BOOLEAN MODE\n     | WITH QUERY EXPANSION\n}<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">FULLTEXT INDEX<\/h3>\n\n\n\n<p>MySQL\uc5d0\uc11c \uc5d0\uc11c FULLTEXT \ud0c0\uc785\uc758 <strong>\uc778\ub371\uc2a4<\/strong>\ub85c Full-Text \uac80\uc0c9\uc744 \uc704\ud574\uc11c\ub294 \uc778\ub371\uc2a4 \uc124\uc815\uc774 \ud544\uc694\ud55c\ub370<\/p>\n\n\n\n<p>\ub370\uc774\ud130 \ud0c0\uc785\uc774 CHAR, VARCHAR, TEXT \uc778 \uacbd\uc6b0\uc5d0\ub9cc FULLTEXT INDEX \uc124\uc815\uc774 \uac00\ub2a5\ud568.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE FULLTEXT INDEX title ON news (title);<\/code><\/pre>\n\n\n\n<p>\uc774\ub54c, \uc601\uc5b4\ub294 \uc798 \uac80\uc0c9\uc774 \ub418\ub098 \ud55c\uae00\uc740 \uc798 \uac80\uc0c9\uc774 \uc548\ub418\ub294 \uc774\uc288.<\/p>\n\n\n\n<p>\uc774\ub97c \uc704\ud574 MySQL fulltext \uac80\uc0c9 \uc54c\uace0\ub9ac\uc998 \uc911, <strong>Ngram<\/strong> \uc0ac\uc6a9.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL\uc740 \ube4c\ud2b8\uc778(\ub0b4\uc7a5)\ub41c Ngram parser\ub97c \uc9c0\uc6d0\ud558\uba70, \uc911\uad6d\uc5b4\uc640 \uc77c\ubcf8\uc5b4 \uadf8\ub9ac\uace0 \ud55c\uae00(CJK)\ub97c \uc9c0\uc6d0<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE FULLTEXT INDEX title ON news (title) WITH PARSER ngram;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Ngram parser<\/h2>\n\n\n\n<p>\uc77c\ub828\uc758 \ud14d\uc2a4\ud2b8\ub97c n\uac1c\uc758 \ubb38\uc790\ub85c \uad6c\uc131\ub41c \uc5f0\uc18d\ub41c \uc2dc\ud000\uc2a4\ub85c \ud1a0\ud070\ud654\ud558\uc5ec \uac80\uc0c9.<\/p>\n\n\n\n<p>ngram \ud30c\uc11c\uc758 \uae30\ubcf8 ngram \ud1a0\ud070 \ud06c\uae30\ub294 2(bigram)\uc774\uba70, \ud55c \uae00\uc790(\ubb38\uc790)\ub9cc \uac80\uc0c9\ud558\ub824\uba74 <strong>ngram_token_size<\/strong>\ub97c 1\ub85c \uc124\uc815\uc774 \ud544\uc694.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ngram_token_size = 1<\/code><\/pre>\n\n\n\n<p>\uc774 \ub54c, ngram \ud30c\uc11c\ub97c \uc0ac\uc6a9\ud558\ub294 FULLTEXT \uc778\ub371\uc2a4\uc758 \uacbd\uc6b0\uc5d0\ub294 \uc544\ub798\uc758 \uad6c\uc131 \uc635\uc158\uc774 \ubb34\uc2dc\ub428.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>innodb_ft_min_token_size<\/strong> \/ innodb_ft_max_token_size<\/li><li><strong>ft_min_word_len<\/strong> \/ ft_max_word_len<\/li><\/ul>\n\n\n\n<h1 class=\"wp-block-heading\">\uac80\uc0c9 \uc720\ud615<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\">1. IN NATURAL LANGUAGE \uac80\uc0c9<\/h2>\n\n\n\n<p>\uac80\uc0c9 \ubb38\uc790\uc5f4\uc744 \ub2e8\uc5b4 \ub2e8\uc704(token_size)\ub85c \ubd84\ub9ac\ud55c \ud6c4, \ud574\ub2f9 \ub2e8\uc5b4 \uc911 \ud558\ub098\ub77c\ub3c4 \ud3ec\ud568\ub418\ub294 \ud589\uc744 \ucc3e\uc74c.<br>\uc790\uc5f0\uc5b4 \uac80\uc0c9\uc740 \uae30\ubcf8 \uac80\uc0c9 \ud0c0\uc785\uc73c\ub85c <strong>MATCH &#8230; AGAINST <\/strong>\uad6c\ubb38\uc5d0 \ubcc4\ub3c4\uc758 \uc635\uc158\uc744 \uc9c0\uce6d\ud558\uc9c0 \uc54a\uc73c\uba74 \uc790\uc5f0\uc5b4 \uac80\uc0c9 \ubaa8\ub4dc\ub85c \uac80\uc0c9\ub428. (\ud639\uc740 AGAINST \uad6c\ubb38\uc5d0 <strong>IN NATURAL LANGUAGE MODE<\/strong> \uc785\ub825)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n  n.seq,\n  n.title\nFROM \n  news AS n\nWHERE \n  MATCH (n.title) AGAINST ('KBO' IN NATURAL LANGUAGE MODE);<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\ub9e4\uce58\uc728<\/h3>\n\n\n\n<p>\uc785\ub825\ub41c \uac80\uc0c9\uc5b4\uc758 \ud0a4\uc6cc\ub4dc\uac00 \uc5bc\ub9c8\ub098 \ub354 \ub9ce\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294\uc9c0\uc5d0 \ub530\ub77c \ub9e4\uce58\uc728(\uc720\uc0ac\uc131 \uce21\uc815\uac12)\uc774 \uacb0\uc815 \ub418\ub294\ub370<br>\uc804\uccb4 \ud14c\uc774\ube14\uc758 50% \uc774\uc0c1\uc758 \ub808\ucf54\ub4dc\uac00 \uac80\uc0c9\ub41c \ud0a4\uc6cc\ub4dc\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \uacbd\uc6b0, \uadf8 \ud0a4\uc6cc\ub4dc\ub294 \uac80\uc0c9\uc5b4\ub85c\uc11c \uc758\ubbf8\uac00 \uc5c6\ub2e4\uace0 \ud310\ub2e8\ud558\uace0 \uac80\uc0c9 \uacb0\uacfc\uc5d0\uc11c \ubc30\uc81c\ub428.<\/p>\n\n\n\n<p>\uc774 \ub54c \ub9e4\uce58\uc728\uc740 row\ub0b4\uc758 \uace0\uc720 \ub2e8\uc5b4 \uc218, \ucd1d \ub2e8\uc5b4 \uc218, \ud2b9\uc815 \ub2e8\uc5b4\ub97c \ud3ec\ud568\ud558\ub294 row \uc218 \ub4f1\uc744 \uae30\uc900\uc73c\ub85c \uacc4\uc0b0\ub418\uba70<br>\uac80\uc0c9 \uacb0\uacfc\ub294 \uac00\uc7a5 \ub192\uc740 \uad00\ub828\uc131\uc744 \uac00\uc9c4 \uacb0\uacfc\ubd80\ud130 \uc790\ub3d9 \uc815\ub82c\ub418\ub294\ub370,&nbsp;\uc544\ub798\uc640 \uac19\uc740 \uc870\uac74\uc5d0 \ud55c\ud574 \uc790\ub3d9 \uc815\ub82c.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>ORDER BY \uc808\uc774 \uc5c6\uc5b4\uc57c \ud568.<\/li><li>\uac80\uc0c9\uc740 \ud14c\uc774\ube14 \uac80\uc0c9\uc774 \uc544\ub2cc FULLTEXT Index\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc218\ud589\ud574\uc57c \ud568.<\/li><li>\ucffc\ub9ac\uac00 \ud14c\uc774\ube14\uc744 \uc870\uc778\ud558\ub294 \uacbd\uc6b0,&nbsp;FULLTEXT Index\ub294 \uc870\uc778\uc5d0\uc11c \uac00\uc7a5 \uc67c\ucabd\uc5d0 \uc788\ub294 non-constant&nbsp;\ud14c\uc774\ube14\uc774\uc5b4\uc57c \ud568.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\ub300\uc18c\ubb38\uc790<\/h3>\n\n\n\n<p>\uae30\ubcf8\uc801\uc73c\ub85c \uac80\uc0c9\uc740 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\ub294 \ubc29\uc2dd\uc73c\ub85c \uc218\ud589.<br>\ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\ub294 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc744 \uc218\ud589\ud558\ub824\uba74 &nbsp;binary collation\uc744 \uc0ac\uc6a9\ud558\uba74\ub428.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uac80\uc0c9\uc5b4 \uae38\uc774<\/h3>\n\n\n\n<p>\uae38\uc774\uac00 \uae30\uc900\ubcf4\ub2e4 \uc9e7\uac70\ub098, \ud2b9\uc815 \ub2e8\uc5b4(Stopword)\ub294 \ud480\ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc5d0\uc11c \ubb34\uc2dc\ub428.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\ucd5c\uc18c \uc778\ub371\uc2f1 \uae00\uc790\uc218 \uc124\uc815\n\ninnodb_ft_min_token_size = 1\nft_min_word_len = 1<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">2. BOOLEAN \uac80\uc0c9<\/h2>\n\n\n\n<p>\ubd88\ub9b0 \ubaa8\ub4dc \uac80\uc0c9\uc740&nbsp;\ubb38\uc790\uc5f4\uc744 \ub2e8\uc5b4 \ub2e8\uc704\ub85c \ubd84\ub9ac\ud55c \ud6c4, \ucd94\uac00\uc801\uc778 \uac80\uc0c9 \uaddc\uce59\uc744 \uc801\uc6a9\ub418\uc5b4\uc11c \ub2e8\uc5b4\uac00 \ud3ec\ud568\ub418\ub294 \ud589\uc744 \ucc3e\uc74c.<br>\ubd88\ub9b0 \ubaa8\ub4dc \uac80\uc0c9\uc740 <strong>IN BOOLEAN MODE<\/strong>\ub97c \uc9c1\uc811 \uc9c0\uc815\ud574\uc11c \uac80\uc0c9\ud560 \uc218 \uc788\uc73c\uba70 \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac80\uc0c9 \uc870\uac74\uc744 \ucd94\uac00 \uac00\ub2a5\ud568.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n  n.seq,\n  n.title\nFROM \n  news AS n\nWHERE \n  MATCH (n.title) AGAINST ('KBO' IN BOOLEAN MODE);<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\uc5f0\uc0b0\uc790<\/h3>\n\n\n\n<p>+ : AND, \ubc18\ub4dc\uc2dc \ud3ec\ud568\ud558\ub294 \ub2e8\uc5b4<\/p>\n\n\n\n<p>&#8211; : NOT, \ubc18\ub4dc\uc2dc \uc81c\uc678\ud558\ub294 \ub2e8\uc5b4<\/p>\n\n\n\n<p>&gt; : \ud3ec\ud568\ud558\uba70, \uac80\uc0c9 \uc21c\uc704\ub97c \ub192\uc77c \ub2e8\uc5b4<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>+mysql &gt;tutorial<ul><li>mysql\uacfc tutorial\uac00 \ud3ec\ud568\ud558\ub294 \ud589\uc744 \ucc3e\uc744 \ub54c, tutorial\uc774 \ud3ec\ud568\ub418\uba74 \uac80\uc0c9 \ub7ad\ud0b9\uc774 \ub192\uc544\uc9d0<\/li><\/ul><\/li><\/ul>\n\n\n\n<p>&lt; : \ud3ec\ud568\ud558\ub418,\uac80\uc0c9 \uc21c\uc704\ub97c \ub0ae\ucd9c \ub2e8\uc5b4<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>+mysql &lt;training<ul><li>mysql\uacfc&nbsp;training\uac00 \ud3ec\ud568\ud558\ub294 \ud589\uc744 \ucc3e\uc9c0\ub9cc, training\uc774 \ud3ec\ud568\ub418\uba74 \uac80\uc0c9 \ub7ad\ud0b9\uc774 \ub0ae\uc544\uc9d0<\/li><\/ul><\/li><\/ul>\n\n\n\n<p>() : \ud558\uc704 \ud45c\ud604\uc2dd\uc73c\ub85c \uadf8\ub8f9\ud654 (\ud3ec\ud568, \uc81c\uc678, \uc21c\uc704 \uc9c0\uc815 \ub4f1)<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>+mysql +(&gt;tutorial &lt;training)<ul><li>mysql AND&nbsp;tutorial,&nbsp;mysql AND training \uc774\uc9c0\ub9cc, tutorial\uc758 \uc6b0\uc120\uc21c\uc704\uac00 \ub354\uc6b1 \ub192\uac8c \uc9c0\uc815<\/li><\/ul><\/li><\/ul>\n\n\n\n<p>~ : &#8216;-&#8216; \uc5f0\uc0b0\uc790\uc640 \ube44\uc2b7\ud558\uc9c0\ub9cc \uc81c\uc678 \uc2dc\ud0a4\uc9c0\ub294 \uc54a\uace0 \uac80\uc0c9 \uc870\uac74\uc744 \ub0ae\ucda4<\/p>\n\n\n\n<p>* : \uc640\uc77c\ub4dc \uce74\ub4dc\ub85c \ubd99\uc74c<\/p>\n\n\n\n<p>\u201c\u201d : \uad6c\ubb38 \uc815\uc758<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. with Query Expansion \uac80\uc0c9<\/h2>\n\n\n\n<p>\uc790\uc5f0\uc5b4 \uac80\uc0c9\uc744 \ud655\uc7a5\ud55c \ub0b4\uc6a9\uc73c\ub85c, 2\ub2e8\uacc4\uc5d0 \uac78\uccd0\uc11c \uac80\uc0c9\uc744 \uc218\ud589.<\/p>\n\n\n\n<p>\uccab \ub2e8\uacc4\uc5d0\uc11c\ub294 \uc790\uc5f0\uc5b4 \uac80\uc0c9\uc744 \uc218\ud589\ud55c \ud6c4,<br>\uccab \ubc88\uc9f8 \uac80\uc0c9\uc758 \uacb0\uacfc\uc5d0 \ub9e4\uce6d\ub41c \ud589\uc744 \uae30\ubc18\uc73c\ub85c \uac80\uc0c9 \ubb38\uc790\uc5f4\uc744 \uc7ac\uad6c\uc131\ud558\uc5ec \ub450 \ubc88\uc9f8 \uac80\uc0c9\uc744 \uc218\ud589\ud568.<\/p>\n\n\n\n<p>\ucffc\ub9ac \ud655\uc7a5 \uac80\uc0c9\uc740 <strong>IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION <\/strong>\ud639\uc740 <strong>WITH QUERY EXPANSION<\/strong>\uc744 \uc9c1\uc811 \uc9c0\uc815\ud574\uc11c \uc0ac\uc6a9.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n  n.seq,\n  n.title\nFROM \n  news AS n\nWHERE \n  MATCH (n.title) AGAINST ('KBO' IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION);\n\nSELECT\n  n.seq,\n  n.title\nFROM \n  news AS n\nWHERE \n  MATCH (n.title) AGAINST ('KBO' WITH QUERY EXPANSION);<\/code><\/pre>\n\n\n\n<p>\ucffc\ub9ac \ud655\uc7a5 \uac80\uc0c9\uc740&nbsp;\uc77c\ubc18\uc801\uc73c\ub85c \uac80\uc0c9 \uad6c\ubb38\uc774 \uc544\uc8fc \uc9e7\uc744 \ub54c \uc720\uc6a9\ud558\uba70<br>\ub9cc\uc57d \ucffc\ub9ac \ud655\uc7a5\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uba74, \ub450 \ubc88\uc9f8 \uac80\uc0c9\uc744 \ud560 \ub54c \uc5d0\uc11c \uc624\ud0c0\ub85c \ucd94\uce21\ub41c \ub2e8\uc5b4\uac00 \ud3ec\ud568\ub41c \ub0b4\uc6a9\uc744 \ucc3e\uc744 \uc218 \uc788\uc74c.<\/p>\n\n\n\n<p>\u201c\uc6d4\ub4dc\ucef5\u201d \uc774\ub77c\ub294 \uac80\uc0c9\uc5b4\uac00 \uc788\uc744 \uacbd\uc6b0.<\/p>\n\n\n\n<p>\uc790\uc5f0\uc5b4 \ubaa8\ub4dc\uc5d0\uc11c\ub294 \u201c\uc6d4\u201d, \u201c\ub4dc\u201d, \u201c\ucef5\u201d \uc6a9\uc5b4 \uc911 \uc77c\uce58\ud558\ub294 \uac8c \uc788\uc73c\uba74 \ucd9c\ub825.<\/p>\n\n\n\n<p>\ubd88\ub9b0 \ubaa8\ub4dc\uc5d0\uc11c\ub294 &#8220;+\uc6d4 +\ub4dc +\ucef5\u201d\ub85c \uac80\uc0c9\ub418\uc5b4 \ucd9c\ub825.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uc911\uc9c0 \ub2e8\uc5b4<\/h2>\n\n\n\n<p>mysql\uc5d0\uc11c \uac00\uc9c0\uace0 \uc788\ub294 \uc911\uc9c0 \ub2e8\uc5b4\uac00 36\uac1c \uc815\ub3c4 \uc788\ub294\ub370 \uc0ac\uc6a9\uc790\uac00 \ubcc4\ub3c4\uc758 \ud14c\uc774\ube14\uc5d0 \uc911\uc9c0 \ub2e8\uc5b4\ub97c \ucd94\uac00\ud55c \ud6c4\uc5d0 \uc801\uc6a9\ud560 \uc218\ub3c4 \uc788\uc74c.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ubc29\ubc95<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\uc911\uc9c0 \ub2e8\uc5b4\ub97c \uc800\uc7a5\ud560 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294\ub370, \uceec\ub7fc\uba85\uc6b4 \ubb34\uc870\uac74 value \ub85c \uc9c0\uc815\ud574\uc57c\ud558\uba70 \ud0c0\uc785\uc740 VARCHAR\ub85c \uc9c0\uc815.<code>CREATE TABLE stop_word_table (value VARCHAR(50));<\/code><\/li><li>\uadf8\ub9ac\uace0 \uc911\uc9c0 \ub2e8\uc5b4\ub97c INSERT<code>INSERT INTO stop_word_table VALUES ('\uadf8\ub9ac\uace0'), ('\ub9e4\uc6b0'), ('\uc65c\ub0d0\ud558\uba74');<\/code><\/li><li>\uc911\uc9c0 \ub2e8\uc5b4 \ud14c\uc774\ube14\ub85c \uc0ac\uc6a9\ud560 \ud14c\uc774\ube14 \uc9c0\uc815<code>SET GLOBAL innodb_ft_server_stopword_table = 'contents\/stop_word_table'; SHOW GLOBAL VARIABLES LIKE 'innodb_ft_server_stopword_table';<\/code><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\uc911\uc9c0\ub2e8\uc5b4\ub3c4 \uac80\uc0c9\uc744 \ud5c8\uc6a9\ud558\uac8c \ud560 \uacbd\uc6b0<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>innodb_ft_enable_stopword = 0<\/code><\/pre>\n\n\n\n<p>\uc778\ub371\uc2a4 \ucd94\uac00 \ud6c4, \ub2e4\uc74c\ub0a0 \ucffc\ub9ac\ub97c \uc2e4\ud589\uc2dc\uc5d0 \uc608\uc0c1\ud588\ub358 \uc778\ub371\uc2a4\ub97c \ud0c0\uc9c0 \uc54a\ub294 \ud604\uc0c1 \ubc1c\uc0dd<\/p>\n\n\n\n<p>\u2192 ANALYZE TABLE {table_name}<\/p>\n\n\n\n<p>Reference.<\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/fulltext-search.html\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/kabkee.github.io\/mysql\/mysql-full-text-search\/#full-text-search-%EB%8F%84%EC%9E%85-%EA%B2%B0%EC%A0%95\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/cotak.tistory.com\/158\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/heowc.dev\/2021\/06\/17\/mysql-index-statistics\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>LIKE \uc5f0\uc0b0\uc744 \ud1b5\ud574 \uac80\uc0c9\uc744 \ud558\uac8c \ub418\uba74 \uc778\ub371\uc2a4\ub97c \ud1b5\ud55c \uac80\uc0c9\uc774 \uc5b4\ub824\uc6b4\ub370 \uc774\ub7f4 \ub54c \uace0\ub824\ud574\ubcfc \uc218 \uc788\ub294 \uac83\uc774 Full-Text \uac80\uc0c9\uc73c\ub85cFullText \uac80\uc0c9\uc740 \ub2e8\uc5b4 \ub610\ub294 \uad6c\ubb38\uc5d0 \ub300\ud55c \uac80\uc0c9\uc744 \uc758\ubbf8. MyISAM\uc740&nbsp;MySQL&nbsp;5.5 \ubc84\uc804 \uc774\uc0c1\ubd80\ud130, innoDB\ub294&nbsp;MySQL&nbsp;5.6 \ubc84\uc804 \ubd80\ud130&nbsp;\uc9c0\uc6d0. \uc2e4\ud589 \ubc29\ubc95 MATCH &#8230; AGAINST \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc740 MATCH AGAINST \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc218\ud589. MATCH\ub294 \uc27c\ud45c\ub85c \uad6c\ubd84\ub418\uba70 \uac80\uc0c9\ud560 \uc5f4\uc744 \uc9c0\uc815\ud558\uba70, AGAINST\ub294 \uac80\uc0c9\ud560 \ubb38\uc790\uc5f4\uacfc \uc218\ud589\ud560 \uac80\uc0c9<\/p>\n<footer class=\"entry-footer index-entry\">\n<div class=\"post-social pull-left\"><a href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Fhappily70.dothome.co.kr%2F%3Fp%3D772\" target=\"_blank\" class=\"social-icons\"><i class=\"fa fa-facebook\" aria-hidden=\"true\"><\/i><\/a><a href=\"https:\/\/twitter.com\/home?status=https%3A%2F%2Fhappily70.dothome.co.kr%2F%3Fp%3D772\" target=\"_blank\" class=\"social-icons\"><i class=\"fa fa-twitter\" aria-hidden=\"true\"><\/i><\/a><a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fhappily70.dothome.co.kr%2F%3Fp%3D772&#038;title=FullText+%EA%B2%80%EC%83%89\" target=\"_blank\" class=\"social-icons\"><i class=\"fa fa-linkedin\" aria-hidden=\"true\"><\/i><\/a><\/div>\n<p class=\"link-more\"><a href=\"https:\/\/happily70.dothome.co.kr\/?p=772\" class=\"more-link\">Continue reading <span class=\"meta-nav\">\u2192<\/span><\/a><\/p>\n<\/footer>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":true,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,64],"tags":[],"class_list":["post-772","post","type-post","status-publish","format-standard","hentry","category-developement","category-mysql"],"_links":{"self":[{"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/772"}],"collection":[{"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=772"}],"version-history":[{"count":4,"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/772\/revisions"}],"predecessor-version":[{"id":777,"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/772\/revisions\/777"}],"wp:attachment":[{"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/happily70.dothome.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}