{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fpgori.hateblo.jp%2Fentry%2F2014%2F01%2F08%2F122900\" title=\"null\u3092concat\u3057\u305f\u3089null\u306b\u306a\u308b - pgori\u306e\u6020\u60f0\u306a\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2014-01-08 12:29:00","description":"\u6587\u5b57\u5217\u3092\u7d50\u5408\u3059\u308b\u3068\u304d\u306b\u4f7f\u7528\u3059\u308b\u95a2\u6570\uff1aconcat select concat(str1, str2, str3, ...) \u306e\u3088\u3046\u306b\u4f7f\u3044\u307e\u3059\u304c\u3069\u308c\u304b\u306e\u5f15\u6570\u304cnull\u3060\u3063\u305f\u5834\u5408null\u304c\u8fd4\u3063\u3066\u304d\u307e\u3059\u3002 null\u3092\u8fd4\u3057\u305f\u304f\u306a\u3044\u5834\u5408\u306fifnull\u3067\u5bfe\u51e6\u3059\u308c\u3070\u3044\u3044\u3093\u3060\u3051\u3069\u3001\u5f15\u6570\u304cnull\u3060\u3063\u305f\u5834\u5408\u305d\u306e\u90e8\u5206\u7a7a\u3063\u3066\u3053\u3068\u306b\u3057\u3066\u304f\u308c\u3066\u3082\u3044\u3044\u3058\u3083\u3093\u30fb\u30fb select concat(ifnull(str1, \"\"), str2, str3, ...) \u53c2\u7167\uff1a http://dev.mysql.com/doc/refman/4.1/ja/string-functions.html","title":"null\u3092concat\u3057\u305f\u3089null\u306b\u306a\u308b","provider_name":"Hatena Blog","type":"rich","categories":["MySQL"],"author_name":"pgori","height":"190","blog_url":"https://pgori.hateblo.jp/","image_url":null,"blog_title":"pgori\u306e\u6020\u60f0\u306a\u30d6\u30ed\u30b0","version":"1.0","author_url":"https://blog.hatena.ne.jp/pgori/","width":"100%","url":"https://pgori.hateblo.jp/entry/2014/01/08/122900","provider_url":"https://hatena.blog"}