sqlCmd += ‘select * from users ‘;
if (realname) {
sqlWhere += ’ and realname like ?’;
sqlParams.push(’%’ + realname + ‘%’);
sqlParams1.push(’%’ + realname + ‘%’);
}
mysql 模糊查询写法
最新推荐文章于 2024-06-06 09:24:50 发布
sqlCmd += ‘select * from users ‘;
if (realname) {
sqlWhere += ’ and realname like ?’;
sqlParams.push(’%’ + realname + ‘%’);
sqlParams1.push(’%’ + realname + ‘%’);
}