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

问题反馈：Op.startsWith 方法在检索数据库时，无法区分字段类型为字符串的 '1_' 和 '13_' #57

Open

924950698 opened this issue Oct 10, 2020 · 1 comment

Labels

924950698 commented Oct 10, 2020 •

edited

Loading

当前使用的 Node.js 版本 (node -v)
v14.13.1

当前使用的 sequelize 版本
"egg-sequelize": "^6.0.0"

问题描述
在调用Op.startsWith 方法在检索数据库时，无法区分字段类型为字符串的 '1_' 和 '13_'；

执行该语句会返回所有满足1_的数据，比如1_1 和 13_1，sequelize有提供精准匹配的like语句吗？

924950698 added the question label

924950698 closed this as completed

Author

924950698 commented Oct 10, 2020

[Op.regexp]: [^${len[i].id}_], // Op.startsWith 无法区分 1_ 与 12_

924950698 reopened this

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