{"categories":["PostgreSQL"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.denzow.me%2Fentry%2F2017%2F09%2F09%2F093548\" title=\"PostgreSQL\u3067\u5168\u6587\u691c\u7d22(pg_bigm\u3092\u8a66\u3057\u3066\u307f\u305f) - [Dd]enzow(ill)? with DB and Python\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2017-09-09 09:35:48","version":"1.0","author_name":"denzow","blog_title":"[Dd]enzow(ill)? with DB and Python","image_url":null,"description":"\u4eca\u56de\u306fPostgreSQL\u3067pg_bigm\u3092\u8a66\u3057\u3066\u307f\u307e\u3059\u3002 SQL\u3067\u5168\u6587\u691c\u7d22\u3092\u8003\u3048\u305f\u3068\u304d\u3001\u3068\u308a\u3042\u3048\u305a\u30c7\u30fc\u30bf\u91cf\u304c\u591a\u304f\u306a\u3051\u308c\u3070LIKE\u691c\u7d22\u3067\u3067\u304d\u307e\u3059\u3002 select data from small_table where data like '%\u308a\u3093\u3054%'; %\u308a\u3093\u3054%\u306e\u6307\u5b9a\u306b\u3088\u308a\u3001\u6587\u4e2d\u306e\u3069\u3053\u304b\u3067\u308a\u3093\u3054\u304c\u542b\u307e\u308c\u308b\u30c7\u30fc\u30bf\u3092\u691c\u7d22\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002%\u306f\u6b63\u898f\u8868\u73fe\u3067\u3044\u3046\u3068\u3053\u308d\u306e*+\u306b\u76f8\u5f53\u3057\u30010\u6587\u5b57\u4ee5\u4e0a\u306e\u4f55\u304b\u306b\u76f8\u5f53\u3057\u307e\u3059\u3002 \u3057\u304b\u3057\u3001\u3053\u306e\u65b9\u6cd5\u3067\u306f\u307b\u3068\u3093\u3069\u306eRDBMS\u3067\u306fINDEX\u304c\u4f7f\u3048\u306a\u3044\u305f\u3081TABLE\u3059\u3079\u3066\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u51fa\u307e\u305b\u3093\u3002\u306a\u304a\u3001\u308a\u3093\u3054%\u3068\u3044\u3063\u305f\u524d\u65b9\u4e00\u81f4\u3067\u3042\u308c\u3070INDEX\u304c\u2026","blog_url":"https://www.denzow.me/","provider_url":"https://hatena.blog","type":"rich","title":"PostgreSQL\u3067\u5168\u6587\u691c\u7d22(pg_bigm\u3092\u8a66\u3057\u3066\u307f\u305f)","height":"190","author_url":"https://blog.hatena.ne.jp/denzow/","provider_name":"Hatena Blog","url":"https://www.denzow.me/entry/2017/09/09/093548","width":"100%"}