关于like

发布日期：2019-12-27

最后更新：2025-11-07 04:49:13

阅读：37,614

http://127.0.0.1?nm=zh

service.selects("HR_USER",condition("NM:%nm%"));
生成对应SQL
SELECT * FROM HR_USER WHERE NM LIKE '%zh%'

service.selects("HR_USER",condition("NM:%nm"));
生成对应SQL
SELECT * FROM HR_USER WHERE NM LIKE '%zh'

service.selects("HR_USER",condition("NM:nm%"));
生成对应SQL
SELECT * FROM HR_USER WHERE NM LIKE 'zh%'