{"id":1109,"date":"2022-01-15T21:28:40","date_gmt":"2022-01-15T12:28:40","guid":{"rendered":"https:\/\/blog.wsd.sh\/?p=1109"},"modified":"2022-01-15T21:29:10","modified_gmt":"2022-01-15T12:29:10","slug":"golang-like%e5%8f%a5%e3%81%ae%e6%8c%87%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/blog.wsd.sh\/?p=1109","title":{"rendered":"<small>golang LIKE\u53e5\u306e%\u6307\u5b9a<\/small>"},"content":{"rendered":"<p>\uff11\uff0egolang LIKE\u53e5\u306e%\u6307\u5b9a<\/p>\n<pre>\r\nSQL := `\r\n   SELECT DISTINCT\r\n      toemail AS email\r\n   FROM\r\n      histories\r\n   WHERE\r\n      fremail LIKE ?\r\n`;\r\n\r\ns := bytes.NewBufferString(\"\");\r\ns.WriteString(SQL);\r\n\r\nrows, err := mast_db.Query(s.String(), year_month, `%`+domain)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uff11\uff0egolang LIKE\u53e5\u306e%\u6307\u5b9a SQL := ` SELECT DISTINCT toemail AS email FROM histories WHERE fremail LIKE ? `; s := bytes&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1109"}],"collection":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1109"}],"version-history":[{"count":2,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1109\/revisions"}],"predecessor-version":[{"id":1115,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=\/wp\/v2\/posts\/1109\/revisions\/1115"}],"wp:attachment":[{"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wsd.sh\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}