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查询语句