ASP LIKE 语句的用法

asp like 在语句中执行查询功能。

当查询为常量时比如从数据库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 wangzhanm

sql="select * from company where name like ' %"&keyword&"% ' order by id desc"

注意，like后面要加个空格，' %"&keyword&"% '前后要加空格

sql = "select * from info where 栏目大类='"&late_class(0)&"' and 区域名称='"&area_city(0)&"' and （信息标题 like '%"&info_key&"%' or 字段1 like '%"&info_key&"%' or 字段2 like '%"&info_key&"%' or ……） order by 发表时间 desc"

---