{"height":"190","width":"100%","blog_title":"Web\u958b\u767a\u306b\u304a\u3051\u308b\u77e5\u898b\u5171\u6709\u7cfb\u30da\u30fc\u30b8","published":"2026-02-11 13:54:10","image_url":null,"blog_url":"https://job-info.hateblo.jp/","author_name":"tomotomo1129","provider_url":"https://hatena.blog","version":"1.0","url":"https://job-info.hateblo.jp/entry/2026/02/11/135410","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fjob-info.hateblo.jp%2Fentry%2F2026%2F02%2F11%2F135410\" title=\"MySQL\u306eLIKE\u691c\u7d22\u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u52b9\u304b\u306a\u3044\u7406\u7531 - Web\u958b\u767a\u306b\u304a\u3051\u308b\u77e5\u898b\u5171\u6709\u7cfb\u30da\u30fc\u30b8\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u3042\u308b\u306e\u306bLIKE\u691c\u7d22\u304c\u9045\u3044\u7406\u7531 B-Tree\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u8f9e\u66f8\u3068\u540c\u3058 \u306a\u305c\u82f1\u8a9e\u3067\u306f\u554f\u984c\u306b\u306a\u308a\u306b\u304f\u3044\u306e\u304b \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u4f7f\u308f\u308c\u306a\u3044\u3082\u30461\u3064\u306e\u7406\u7531 EXPLAIN\u3067\u78ba\u8a8d\u3059\u308b \u3088\u304f\u3042\u308b\u8aa4\u89e3 \u73fe\u5b9f\u7684\u306a\u89e3\u6c7a\u7b56 \u524d\u65b9\u4e00\u81f4\u306b\u5909\u3048\u308b FULLTEXT\u30a4\u30f3\u30c7\u30c3\u30af\u30b9 \u691c\u7d22\u5c02\u7528\u30ab\u30e9\u30e0\u3092\u4f5c\u308b \u6ce8\u610f\u70b9\u3068\u30ea\u30b9\u30af LIKE\u691c\u7d22\u306e\u672c\u8cea \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u3042\u308b\u306e\u306bLIKE\u691c\u7d22\u304c\u9045\u3044\u7406\u7531 MySQL\u3067\u691c\u7d22\u6a5f\u80fd\u3092\u5b9f\u88c5\u3059\u308b\u3068\u3001\u591a\u304f\u306e\u4eba\u304c\u4e00\u5ea6\u306f\u6df7\u4e71\u3057\u307e\u3059\u3002 \u300c\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8cbc\u3063\u305f\u306e\u306b\u9045\u3044\u300d\u7279\u306b\u6b21\u306e\u3088\u3046\u306aSQL\u3067\u3059\u3002 SELECT * FROM users WHERE name LIKE '%\u7530\u4e2d%'; \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u8a2d\u5b9a\u3055\u308c\u2026","type":"rich","categories":["MySQL","LIKE\u691c\u7d22","\u30a4\u30f3\u30c7\u30c3\u30af\u30b9","\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9","FULLTEXT"],"author_url":"https://blog.hatena.ne.jp/tomotomo1129/","provider_name":"Hatena Blog","title":"MySQL\u306eLIKE\u691c\u7d22\u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u52b9\u304b\u306a\u3044\u7406\u7531"}