Kenji Okimoto
null+****@clear*****
Wed Feb 3 11:02:01 JST 2016
Kenji Okimoto 2016-02-03 11:02:01 +0900 (Wed, 03 Feb 2016) New Revision: 410e147e0d9b756e907f635412f966a1f953cb06 https://github.com/pgroonga/pgroonga.github.io/commit/410e147e0d9b756e907f635412f966a1f953cb06 Merged b640b27: Merge pull request #15 from okkez/fix-tutorial-like Message: Use `LIKE` in example Modified files: ja/tutorial/index.md tutorial/index.md Modified: ja/tutorial/index.md (+1 -1) =================================================================== --- ja/tutorial/index.md 2016-02-03 11:01:40 +0900 (647d0aa) +++ ja/tutorial/index.md 2016-02-03 11:02:01 +0900 (c8f3ffe) @@ -124,7 +124,7 @@ PGroongaは`LIKE`演算子をサポートしています。既存のSQLを変更 `column LIKE '%キーワード%'`は`column %% 'キーワード'`と等価です。 ```sql -SELECT * FROM memos WHERE content %% '全文検索'; +SELECT * FROM memos WHERE content LIKE '%全文検索%'; -- id | content -- ----+--------------------------------------------------- Modified: tutorial/index.md (+1 -1) =================================================================== --- tutorial/index.md 2016-02-03 11:01:40 +0900 (0209484) +++ tutorial/index.md 2016-02-03 11:02:01 +0900 (a46d68b) @@ -123,7 +123,7 @@ PGroonga supports `LIKE` operator. You can perform fast full text search by PGro `column LIKE '%keyword%'` equals to `column %% 'keyword'`: ```sql -SELECT * FROM memos WHERE content %% 'engine'; +SELECT * FROM memos WHERE content like '%engine%'; -- id | content -- ----+------------------------------------------------------------------------ -- 2 | Groonga is a fast full text search engine that supports all languages. -------------- next part -------------- HTML����������������������������... 다운로드