<!DOCTYPE html>
<html>
<head>
</head>
<body>
<dl style="line-height: 1.5; margin-left: 2em">
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Author</dt>
<dd style="margin-left: 8.5em">Kouhei Sutou <kou****@clear*****></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt>
<dd style="margin-left: 8.5em">2015-10-06 23:58:12 +0900 (Tue, 06 Oct 2015)</dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">New Revision</dt>
<dd style="margin-left: 8.5em"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66">39076ec1923166b3996b418e105dc379a2c4eb66</a></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt>
<dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">Translate LIKE operator</pre></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt>
<dd style="margin-left: 8.5em">
<ul>
<li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527">reference/create-index-using-pgroonga.md</a></li>
<li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53">reference/operators/like.md</a></li>
</ul>
</dd>
</dl>
<div class="diff-section" style="clear: both">
<table style="border-collapse: collapse; border: 1px solid #aaa">
<thead>
<tr class="diff-header" style="border: 1px solid #aaa">
<td colspan="3">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: reference/create-index-using-pgroonga.md (+2 -0)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527L36">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527L37">37</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527L38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527L39">39</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527L40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527L41">41</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527L42">42</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527R36">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527R37">37</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527R38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527R39">39</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527R40">40</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527R41">41</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527R42">42</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527R43">43</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-2348298c2ffbf92ae17422df9186a527R44">44</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -37,6 +37,8 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE INDEX ${INDEX_NAME}</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> You need to specify `pgroonga.varchar_fulltext_search_ops` operator class for the case.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+{: #customization}</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ### Customization</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> You can custom the followings by `WITH` option of `CREATE INDEX`:</span>
</pre>
</td>
</tr>
</tbody>
</table>
<table style="border-collapse: collapse; border: 1px solid #aaa">
<thead>
<tr class="diff-header" style="border: 1px solid #aaa">
<td colspan="3">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: reference/operators/like.md (+13 -26)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L4">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L7">7</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L8">8</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L9">9</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L10">10</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L11">11</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L12">12</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L13">13</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L14">14</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L15">15</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L16">16</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L17">17</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L18">18</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L19">19</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L20">20</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L21">21</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L22">22</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L23">23</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L24">24</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L25">25</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L28">28</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L34">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L36">36</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L37">37</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L38">38</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L41">41</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L49">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L50">50</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L51">51</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L52">52</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L53">53</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L54">54</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L55">55</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L56">56</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L57">57</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L58">58</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L59">59</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L60">60</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L61">61</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L62">62</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L63">63</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L66">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L67">67</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L68">68</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L69">69</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L70">70</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L71">71</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L72">72</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L73">73</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L74">74</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L80">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L81">81</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L82">82</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L83">83</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L84">84</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L85">85</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L86">86</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53L87">87</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R4">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R5">5</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R6">6</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R7">7</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R8">8</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R9">9</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R10">10</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R11">11</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R12">12</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R13">13</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R14">14</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R15">15</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R16">16</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R17">17</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R18">18</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R19">19</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R25">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R28">28</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R29">29</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R30">30</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R31">31</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R32">32</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R40">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R41">41</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R42">42</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R43">43</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R45">45</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R46">46</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R47">47</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R48">48</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R49">49</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R50">50</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R51">51</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R52">52</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R55">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R56">56</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R57">57</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R58">58</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R59">59</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R60">60</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R61">61</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R62">62</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R68">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R69">69</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R70">70</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R71">71</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R72">72</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R73">73</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/39076ec1923166b3996b418e105dc379a2c4eb66#diff-274aa778ac04b071db2006aec4aa3f53R74">74</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -5,24 +5,15 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">layout: en</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> # `LIKE` operator</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-TODO</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+PGroonga converts `column LIKE '%KEYWORD%'` condition to `column @@ 'KEYWORD'` internally. [`@@` operator](match.html) does full text search with index. It's fast rather than `LIKE` operator without index.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-なお、`'キーワード%'`や`'%キーワード'`のように最初と最後に`%`がついて</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-いない場合は必ず検索結果が空になります。このようなパターンはインデック</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-スを使って検索できないからです。気をつけてください。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+Both beginning `%` and ending `%` are important. `'KEYWORD%'`, `'%KEYWORD'` and so on aren't converted to `column @@ 'KEYWORD'`. PGroonga returns no records for these patterns. Because PGroonga can't search these patterns with index.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-本来の`LIKE`演算子は元の文字列そのものに対して検索しますが、`@@`演算子</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-は正規化後の文字列に対して全文検索検索を実行します。そのため、インデッ</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-クスを使わない場合の`LIKE`演算子の結果（本来の`LIKE`演算子の結果）とイ</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-ンデックスを使った場合の`LIKE`演算子の結果は異なります。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+The original `LIKE` operator searches against text as is. But `@@` operator does full text search against normalized text. It means that search result of `LIKE` operator with index and search result of the original `LIKE` operator may be different.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-たとえば、本来の`LIKE`演算子ではアルファベットの大文字小文字を区別した</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-りいわゆる全角・半角を区別しますが、インデックスを使った場合は区別なく</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-検索します。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+For example, the original `LIKE` operator searches with case sensitive. But `LIKE` operator with index searches with case insensitive.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-本来の`LIKE`演算子の結果:</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+A search result of the original `LIKE` operator:</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```sql</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_seqscan = on;</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -35,7 +26,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">SELECT * FROM memos WHERE content LIKE '%groonga%';</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> -- (1 行)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-インデックスを使った`LIKE`演算子の結果:</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+A search result of `LIKE` operator with index:</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```sql</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_seqscan = off;</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -50,14 +41,12 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">SELECT * FROM memos WHERE content LIKE '%groonga%';</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> -- (3 行)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-インデックスを使った場合でも本来の`LIKE`演算子と同様の結果にしたい場合</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-は次のようにトークナイザー（後述）とノーマライザー（後述）を設定してイ</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-ンデックスを作成してください。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+If you want to get the same result by both `LIKE` operator with index and the original `LIKE` operator, use the following tokenizer and normalizer:</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- * トークナイザー: `TokenBigramSplitSymbolAlphaDigit`</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- * ノーマライザー: なし</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ * Tokenizer: `TokenBigramSplitSymbolAlphaDigit`</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ * Normalizer: None</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-具体的には次のようにインデックスを作成します。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+Here is a concrete example:</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```sql</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> CREATE INDEX pgroonga_content_index</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -67,8 +56,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">CREATE INDEX pgroonga_content_index</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> normalizer='');</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-このようなインデックスを作っているときはインデックスを使った`LIKE`演算</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-子でも本来の`LIKE`演算子と同様の挙動になります。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+You can get the same result as the original `LIKE` operator with `LIKE` operator with index:</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```sql</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> SET enable_seqscan = off;</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -81,7 +69,6 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">SELECT * FROM memos WHERE content LIKE '%groonga%';</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> -- (1 行)</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ```</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-多くの場合、デフォルトの設定の全文検索結果の方が本来の`LIKE`演算子の方</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-の検索結果よりもユーザーが求めている結果に近くなります。本当に本来の</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-`LIKE`演算子の挙動の方が適切か検討した上で使ってください。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+Normally, the default configuration returns better result for full text search rather than the original `LIKE` operator. Think about which result is better for users before you change the default configuration.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+See [Customization in `CREATE INDEX USING pgroonga`](../create-index-using-pgroonga.html#customization) for tokenizer and normalizer.</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>