we need to give users the ability to search by keywords......what's a good workaround for this without using FTS?
any advice?
thanks.
G.Create queries that use the wildcart % for all the fields you want to search in ...
Only way you can do it ...|||Here is a nice example of some searching logic.
http://weblogs.sqlteam.com/jeffs/archive/2004/11/02/2460.aspx|||
% wildcards work really slow u should be carefull...
find a way to use full text search.
sql
没有评论:
发表评论