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

建议 QueryWrapper 增加忽略大小写的 like,例如 ilike #5864

Open
someok opened this issue Dec 20, 2023 · 5 comments
Open

建议 QueryWrapper 增加忽略大小写的 like,例如 ilike #5864

someok opened this issue Dec 20, 2023 · 5 comments

Comments

@someok
Copy link

someok commented Dec 20, 2023

rt

目前这类查询还是挺多的,完全可以增加个 ilike 进行忽略大小写的查询,应该也不复杂:

lower(field) like lower(value)

@miemieYaho
Copy link
Member

所有数据库通用吗?

@someok
Copy link
Author

someok commented Dec 21, 2023

基本算是个通用的了,例如 oracle、sql server、MySQL、postgresql 都支持

@chess3cake
Copy link

可以提供一些方言wrapper吗,比如PgSqlQueryWrapper之类的 @miemieYaho

@adinlead
Copy link

adinlead commented Jan 3, 2024

可以提供一些方言wrapper吗,比如PgSqlQueryWrapper之类的 @miemieYaho

是不是可以考虑使用apply方法拼接?

@chess3cake
Copy link

可以提供一些方言wrapper吗,比如PgSqlQueryWrapper之类的 @miemieYaho

是不是可以考虑使用apply方法拼接?

apply的话就是一部分sql是手写的了,我们的团队更倾向于使用lambda语法。目前我们是通过适配器模式做了自己的wrapper。

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

No branches or pull requests

5 participants