New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

How to use 'like' ? #47

Closed

0312birdzhang opened this issue Jul 29, 2016 · 1 comment

0312birdzhang commented Jul 29, 2016 •

edited

Loading

Such like select filename,md5,dfspath from dfs_mapping where uri like '%player2116702552%',i found it not working.

The text was updated successfully, but these errors were encountered:

Author

0312birdzhang commented Jul 29, 2016

My fault,it works.

local domain = ngx.var.http_host
-- ngx.say("domain:",domain)
local sql1 = [[ 
                  select a.filename,a.md5,a.dfspath 
                  from dfs_mapping a left join dfs_apps b on a.appid = b.appid 
                  where a.uri =']] .. uri .. [[' and b.appzone like  '%]] .. domain .. "%'"

0312birdzhang closed this as completed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment