{"title":"\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3063\u3066LIKE\u3067\u691c\u7d22\u3059\u308b\uff08SQL Server\uff09","provider_url":"https://hatena.blog","type":"rich","blog_url":"https://pumpkin.hatenablog.jp/","url":"https://pumpkin.hatenablog.jp/entry/20081031/1225456723","author_url":"https://blog.hatena.ne.jp/takeru-c/","width":"100%","height":"190","author_name":"takeru-c","provider_name":"Hatena Blog","categories":["SQL"],"published":"2008-10-31 21:38:43","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fpumpkin.hatenablog.jp%2Fentry%2F20081031%2F1225456723\" title=\"\u6b63\u898f\u8868\u73fe\u3092\u4f7f\u3063\u3066LIKE\u3067\u691c\u7d22\u3059\u308b\uff08SQL Server\uff09 - \u30d1\u30f3\u30d7\u30ad\u30f3\u30b9\u30d1\u30a4\u30b9\u30e9\u30c6\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"\u7d22\u5f15\u691c\u7d22\u3092\u4f5c\u3063\u3066\u3066\u300150\u97f3\uff08\u3042\u301c\u3093\uff09\u4ee5\u5916\u306e\u3082\u306e\u3092\u53d6\u308a\u51fa\u3059SQL\u6587\u3092\u3069\u3046\u3057\u3088\u3046\u304b\u60a9\u3093\u3067\u305f\u3002 not like '\u3042%' and not like '\u3044%' \u30fb\u30fb\u30fb\u30fb \u3063\u3066\u3084\u308b\u306e\u306f\u660e\u3089\u304b\u306b\u52b9\u7387\u304c\u60aa\u3044\u3057\u3001\u898b\u305f\u76ee\u3082\u6c5a\u3044\u3002 \u8abf\u3079\u3066\u307f\u305f\u3089\u6b63\u898f\u8868\u73fe\u3067\u4e00\u767a\u3067\u3067\u304d\u305f\uff01\uff01 select * from table where column not like '[\u3041-\u3093]% ; \u52d5\u4f5c\u78ba\u8a8d\u306fSQL Server2005\u3067\u3059\u3002","version":"1.0","blog_title":"\u30d1\u30f3\u30d7\u30ad\u30f3\u30b9\u30d1\u30a4\u30b9\u30e9\u30c6"}