SELECT DP_ArticleList.ArticleID, DP_ArticleList.ArticleClassID,
DP_ArticleList.ArticleTitle, DP_ArticleList.ArticleContent, DP_Class_1.ClassID,
DP_Class_1.ClassName
FROM DP_Class AS DP_Class_1 INNER JOIN
DP_ArticleList ON DP_Class_1.ClassID = DP_ArticleList.ArticleClassID
WHERE (DP_ArticleList.ArticleTitle LIKE '%.net%')共20多万条数据.从DP_ArticleList.ArticleTitle中去匹配%.net%(随便取一个先,是做网页搜索的,所以不是固定值.取的是request.form("query")速度慢的实在是受不了.这还只是从title中查询呢..如果从content中查询,那怎么办啊.大家帮我想想办法吧.我第一次来这里.就十分了.
DP_ArticleList.ArticleTitle, DP_ArticleList.ArticleContent, DP_Class_1.ClassID,
DP_Class_1.ClassName
FROM DP_Class AS DP_Class_1 INNER JOIN
DP_ArticleList ON DP_Class_1.ClassID = DP_ArticleList.ArticleClassID
WHERE (DP_ArticleList.ArticleTitle LIKE '%.net%')共20多万条数据.从DP_ArticleList.ArticleTitle中去匹配%.net%(随便取一个先,是做网页搜索的,所以不是固定值.取的是request.form("query")速度慢的实在是受不了.这还只是从title中查询呢..如果从content中查询,那怎么办啊.大家帮我想想办法吧.我第一次来这里.就十分了.
DP_ArticleList.ArticleTitle, DP_ArticleList.ArticleContent, DP_Class_1.ClassID,
DP_Class_1.ClassName
FROM DP_Class AS DP_Class_1 INNER JOIN
DP_ArticleList ON DP_Class_1.ClassID = DP_ArticleList.ArticleClassID
WHERE charindex('.net', DP_ArticleList.ArticleTitle)>0
然后在asp或asp.net中怎么写查询???
好象是这样,记不太清楚了