{"action":"created","issue":{"url":"https://api.github.com/repos/openresty/lua-resty-mysql/issues/47","repository_url":"https://api.github.com/repos/openresty/lua-resty-mysql","labels_url":"https://api.github.com/repos/openresty/lua-resty-mysql/issues/47/labels{/name}","comments_url":"https://api.github.com/repos/openresty/lua-resty-mysql/issues/47/comments","events_url":"https://api.github.com/repos/openresty/lua-resty-mysql/issues/47/events","html_url":"https://github.com/openresty/lua-resty-mysql/issues/47","id":168290759,"number":47,"title":"How to use 'like' ?","user":{"login":"0312birdzhang","id":1762041,"avatar_url":"https://avatars.githubusercontent.com/u/1762041?v=3","gravatar_id":"","url":"https://api.github.com/users/0312birdzhang","html_url":"https://github.com/0312birdzhang","followers_url":"https://api.github.com/users/0312birdzhang/followers","following_url":"https://api.github.com/users/0312birdzhang/following{/other_user}","gists_url":"https://api.github.com/users/0312birdzhang/gists{/gist_id}","starred_url":"https://api.github.com/users/0312birdzhang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/0312birdzhang/subscriptions","organizations_url":"https://api.github.com/users/0312birdzhang/orgs","repos_url":"https://api.github.com/users/0312birdzhang/repos","events_url":"https://api.github.com/users/0312birdzhang/events{/privacy}","received_events_url":"https://api.github.com/users/0312birdzhang/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-29T09:55:55Z","updated_at":"2016-07-29T10:09:55Z","closed_at":"2016-07-29T10:09:55Z","body":"Such like <code>select filename,md5,dfspath from dfs_mapping where uri like '%player2116702552%'</code>,i found it not working.\r\n"},"comment":{"url":"https://api.github.com/repos/openresty/lua-resty-mysql/issues/comments/236144254","html_url":"https://github.com/openresty/lua-resty-mysql/issues/47#issuecomment-236144254","issue_url":"https://api.github.com/repos/openresty/lua-resty-mysql/issues/47","id":236144254,"user":{"login":"0312birdzhang","id":1762041,"avatar_url":"https://avatars.githubusercontent.com/u/1762041?v=3","gravatar_id":"","url":"https://api.github.com/users/0312birdzhang","html_url":"https://github.com/0312birdzhang","followers_url":"https://api.github.com/users/0312birdzhang/followers","following_url":"https://api.github.com/users/0312birdzhang/following{/other_user}","gists_url":"https://api.github.com/users/0312birdzhang/gists{/gist_id}","starred_url":"https://api.github.com/users/0312birdzhang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/0312birdzhang/subscriptions","organizations_url":"https://api.github.com/users/0312birdzhang/orgs","repos_url":"https://api.github.com/users/0312birdzhang/repos","events_url":"https://api.github.com/users/0312birdzhang/events{/privacy}","received_events_url":"https://api.github.com/users/0312birdzhang/received_events","type":"User","site_admin":false},"created_at":"2016-07-29T10:09:55Z","updated_at":"2016-07-29T10:09:55Z","body":"My fault,it works.\r\n\r\n```\r\nlocal domain = ngx.var.http_host\r\n-- ngx.say(\"domain:\",domain)\r\nlocal sql1 = [[ \r\n                  select a.filename,a.md5,a.dfspath \r\n                  from dfs_mapping a left join dfs_apps b on a.appid = b.appid \r\n                  where a.uri =']] .. uri .. [[' and b.appzone like  '%]] .. domain .. \"%'\"\r\n```"}}
{"actor":{"display_login":"0312birdzhang"}}