droonga/presentation-trbmeetup-droonga at 46644e6 [master] Add SQL examples for Mroonga and PGroonga (Groonga-commit) - Groonga - fulltext search engine.

YUKI Hiroshi	2015-02-09 12:07:59 +0900 (Mon, 09 Feb 2015)

  New Revision: 46644e696235cd4d984a95a4fe309b02bd382c7c
  https://github.com/droonga/presentation-trbmeetup-droonga/commit/46644e696235cd4d984a95a4fe309b02bd382c7c

  Message:
    Add SQL examples for Mroonga and PGroonga

  Modified files:
    fast-fulltext-search-in-ruby-groonga-rroonga-droonga.md

  Modified: fast-fulltext-search-in-ruby-groonga-rroonga-droonga.md (+28 -0)
===================================================================

--- fast-fulltext-search-in-ruby-groonga-rroonga-droonga.md    2015-02-09 11:10:59 +0900 (381430a)
+++ fast-fulltext-search-in-ruby-groonga-rroonga-droonga.md    2015-02-09 12:07:59 +0900 (3acbfb0)
@@ -384,6 +384,34 @@ $ curl "${endpoint}/d/table_create?name=Store&
 ![](images/mroonga-pgroonga.png){:relative_width="80"}
 
 
+# SQL w/ fulltext search
+
+Mroonga
+
+~~~
+SELECT name,location
+  FROM Store
+ WHERE MATCH(name) AGAINST('東京');
+~~~
+{: lang="sql"}
+
+
+# SQL w/ fulltext search
+
+PGroonga
+
+~~~
+SELECT name,location
+  FROM Store
+ WHERE name %% '東京';
+
+SELECT name,location
+  FROM Store
+ WHERE name @@ '東京 OR 大阪';
+~~~
+{: lang="sql"}
+
+
 # Conclusion
 
  * *Rroonga* (and *GrnMini*) introduces fast fulltext search into your Ruby product instantly
-------------- next part --------------
HTML����������������������������...
Descargar 


Groonga - fulltext search engine.

[Groonga-commit] droonga/presentation-trbmeetup-droonga at 46644e6 [master] Add SQL examples for Mroonga and PGroonga