关于模糊查询语句

[IT_Fish]

因为我需要实现模糊查询
sql = "select * from product where lb like '%" & key & "'%"
因为lb列有重复，我要的结果不需要重复的纪录
所以我想问下
sql = "select * from product where lb like '%" & key & "'% group by lb"
可以用这语句来打开数据库实现搜索么？

[游陆]

sql = "select distinct * from product where lb like '%" & key & "%'"

[xutao888]

sql = "select * from product where ID in(Select Max(ID) From product Group By 不重复的字段) lb like '%" & key & "%'"

[IT_Fish]

楼上的兄弟，你的办法好像还是不行，会出现下面的提示信息：
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC driver does not support the requested properties.
/dwt/search.asp, line 20

[devilzone]

不行

[JasonJHu]

应该可以的

[JasonJHu]

好像可以用UNION吧

[beiouwolf]

sql = "select * from product DISTINCT where lb like '%" & key & "'%"
加DISTINCT就行了

[wooernet]

不行，
用DISTINCT
具体看SQL 联机帮助的select，你会学到更多

[IT_Fish]

好像都不行，谁帮我看看写个搜索语句啊

[IT_Fish]

试了好个SQL语句，可是好像没有可以达到效果的…… 郁闷……