<!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-07 00:08:48 +0900 (Wed, 07 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/4722457d3a9779738c0266c7dc5be096029c2ce0">4722457d3a9779738c0266c7dc5be096029c2ce0</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 match 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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-274aa778ac04b071db2006aec4aa3f53">reference/operators/like.md</a></li>
<li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6">reference/operators/match.md</a></li>
<li><a href="https://github.com/pgroonga/pgroonga.github.io/commit/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35cc">reference/operators/query.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/operators/like.md (+3 -3)</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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-274aa778ac04b071db2006aec4aa3f53L10">10</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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-274aa778ac04b071db2006aec4aa3f53L13">13</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-274aa778ac04b071db2006aec4aa3f53L14">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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-274aa778ac04b071db2006aec4aa3f53L15">15</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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-274aa778ac04b071db2006aec4aa3f53R9">9</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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-274aa778ac04b071db2006aec4aa3f53R11">11</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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-274aa778ac04b071db2006aec4aa3f53R13">13</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/4722457d3a9779738c0266c7dc5be096029c2ce0#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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-274aa778ac04b071db2006aec4aa3f53R15">15</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,11 +5,11 @@ <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">-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-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">-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-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">-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-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-not-changed" style="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>
</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/match.md (+13 -3)</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6">...</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6L1">1</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6L2">2</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6L3">3</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6L4">4</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6L5">5</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6L6">6</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6L7">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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6L8">8</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-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-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>
</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6">...</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R1">1</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R2">2</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R3">3</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R4">4</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R5">5</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R6">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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R7">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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R8">8</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R9">9</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R10">10</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R11">11</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R12">12</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R13">13</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R14">14</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R15">15</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R16">16</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R17">17</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-90cd07117e03130d02dbb80450d826f6R18">18</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">@@ -1,8 +1,18 @@</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">-title: "@@ operator"</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+title: "%% operator"</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> layout: en</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">-# `@@` operator</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+# `%%` 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">+You can do full text search with one keyword by `%%` operator:</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+```sql</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SELECT * FROM memos WHERE content %% '全文検索';</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+-- id | content</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+-- ----+---------------------------------------------------</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+-- 2 | Groongaは日本語対応の高速な全文検索エンジンです。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+-- (1 行)</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+```</span>
<span class="diff-added" style="background-color: #aaffaa; 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 do full text search with multiple keywords or AND/OR search, use [`%%` operator](query.html).</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/query.md (+17 -3)</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35cc">...</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL1">1</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL2">2</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL3">3</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL4">4</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL5">5</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL6">6</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL7">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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL8">8</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-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-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-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-not-changed" style="display: block; white-space: pre"><a href="https://github.com/pgroonga/pgroonga.github.io/commit/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL9">9</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL10">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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccL11">11</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35cc">...</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR1">1</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR2">2</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR3">3</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR4">4</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR5">5</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR6">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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR7">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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR8">8</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR9">9</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR10">10</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR11">11</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR12">12</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR13">13</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR14">14</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR15">15</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR16">16</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR17">17</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR18">18</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR19">19</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR20">20</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR21">21</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR22">22</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR23">23</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR24">24</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/4722457d3a9779738c0266c7dc5be096029c2ce0#diff-05a62d3f005775702d62b1df842a35ccR25">25</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">@@ -1,11 +1,25 @@</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">-title: "%% operator"</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+title: "@@ operator"</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> layout: en</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">-# `%%` operator</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+# `@@` 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">+`キーワード1 OR キーワード2`のようにクエリー構文を使って全文検索をする</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ときは`@@`演算子を使います。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+```sql</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+SELECT * FROM memos WHERE content @@ 'PGroonga OR PostgreSQL';</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+-- id | content</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+-- ----+---------------------------------------------------------------------------</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+-- 3 | PGroongaはインデックスとしてGroongaを使うためのPostgreSQLの拡張機能です。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+-- 1 | PostgreSQLはリレーショナル・データベース管理システムです。</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+-- (2 行)</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+```</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+クエリー構文の詳細は</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+[Groognaのドキュメント](http://groonga.org/ja/docs/reference/grn_expr/query_syntax.html)</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"> </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>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>