关于like

最后更新:2023-10-18 21:21:50 | 状态:未完成
http://127.0.0.1?nm=zh
service.querys("HR_USER",condition("NM:%nm%"));
生成对应SQL
SELECT * FROM HR_USER WHERE NM LIKE '%zh%'
service.querys("HR_USER",condition("NM:%nm"));
生成对应SQL
SELECT * FROM HR_USER WHERE NM LIKE '%zh'
service.querys("HR_USER",condition("NM:nm%"));
生成对应SQL
SELECT * FROM HR_USER WHERE NM LIKE 'zh%'
最近更新 搜索 提交