asp like
asp like 的使用
asp like 在sql语句中执行查询的功能句子。
当查询为常量时比如从数据库shujuku中查询网站名字wangzhanming 为forasp的记录
那么语句为
"select wangzhanming from shujuku wangzhanming='forasp'"
查询为变量时
nam="forasp"
"select wangzhanming from shujuku where wangzhanming='"&nam&"'"
下面讲asp 中like的用法
当查询为常量时
1.like查询“forasp....”
"select wangzhanming from shujuku wangzhanming wherer wangzhanming like 'forasp%'"
2.like查询“...forasp”
"select wangzhanming from shujuku wangzhanming wherer wangzhanming like '%forasp'"
3.like查询“...forasp...”
"select wangzhanming from shujuku wangzhanming wherer wangzhanming like '%forasp%'"
当查询为变量事
比如 nam="forasp"
1.like查询“forasp....”
"select wangzhanming from shujuku wangzhanming wherer wangzhanming like '"&nam&"%'"
2.like查询“...forasp”
"select wangzhanming from shujuku wangzhanming wherer wangzhanming like '%"&nam&"'"
3.like查询“...forasp...”
"select wangzhanming from shujuku wangzhanming wherer wangzhanming like '%"&nam&"%'"
asp 中的like 在查询中经常常用所以要好好学习
关键词:asp like asp中like sql查询语句