Skip to content
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.

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

请问,'not like' 要怎么写。 #129

Open
3DMXM opened this issue Apr 8, 2021 · 2 comments
Open

请问,'not like' 要怎么写。 #129

3DMXM opened this issue Apr 8, 2021 · 2 comments

Comments

@3DMXM
Copy link

3DMXM commented Apr 8, 2021

因为需要,要筛选“不包含某些字符”的数据,要用到not like来进行操作,发现好像不支持。。。

@billge1205
Copy link
Collaborator

是的 not like api里是没做支持,也不建议使用, 如果一定要用,可以参考sql模板
http://www.billge.cc/#dao-command

$result = $this->userDAO->filter(array('id'=>10))
    ->select("select * from :table WHERE :where and `column` not like `%xxx%`;");

@billge1205
Copy link
Collaborator

not like 现在支持了,同时也支持了regexp,用法跟其他运算符一致,参考文档
http://www.billge.cc/#dao-extracts

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants