LIKE模糊查询userName包含A字母的数据(%A%)
SQL:SELECT * FROM UserInfo WHERE userName LIKE "%A%"
MongoDB:db.UserInfo.find({userName :/A/})
LIKE模糊查询userName以字母A开头的数据(A%)。
SQL:SELECT * FROM UserInfo WHERE userName LIKE "A%"
MongoDB:db.UserInfo.find({userName :/^A/})
//node.js模糊查询
var query={};
query['column']=new RegExp(key);//模糊查询参数
dbInstance.count("table",query,function(err,counts){
});