SQL语句找错

来源：百度知道 编辑：UC知道 时间：2024/07/08 04:28:18
sql="SELECT top 10 * FROM CU_Art where " & Left(Title,Len(request("search"))) &"='"& request("search") & "' order by id desc"

其中CU_Art是表，Title是表中的一个列。
我想查询Title列中的前几个字符整好是查询的字符的记录。

sql="SELECT top 10 * FROM CU_Art where Left(Title,"&Len(request("search"))&")='"& request("search") & "' order by id desc"

sql="SELECT top 10 * FROM CU_Art where Title='"& request("search") & "' order by id desc"
或者
sql="SELECT top 10 * FROM CU_Art where Title like '%"& request("search") & "%' order by id desc"

where " & Left(Title,Len(request("search"))) &"='"& request("search") & "' order by id desc" 有错误!
应该是:

where title='"& request("search") & "' order by id desc"