菜鸟问个检索的问题,高手帮忙

access数据库,某一条记录中,字段name为“中国创业投资与搞科技”,用“创业投资”作为关键词检索,要检索出该记录,如何实现。
---------------------------------------------------------------

select * from tab where name like '%创业投资%'
---------------------------------------------------------------

select name form table where keys="创业投资"
---------------------------------------------------------------

select * from table where name like '%"创业投资"%';
select * from table where name like '__"创业投资"____';
_也可能是或者?吧,因为在access里面是或者?,可是用程序传过去不一定了
---------------------------------------------------------------

上面再失误:
keys=request.form("keys")
...
select name from table where name="&keys&"
...

---------------------------------------------------------------

这个问题竞然回答出这么多的结果,可怜楼主啊,又茫然了.

同意:

最终版:
...
keys=trim(Request.Form("keys"))
...
sql="Select name From table Where name like '%"&keys&"%' Order By ID"
...

Published At
Categories with Web编程
Tagged with
comments powered by Disqus