关于全文检索中的问题

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

YuQ - 14 Apr 2008 08:10 GMT

Dears，

我们在使用MS SQL Server全文检索时，碰到如下问题，请各位大侠解释一下原因。

我们分别用“品位”和“品”查询某个text数据类型，发现结果很奇怪。

查询条件＝“品位”，在结果中看到该一笔记录如下：
Code＝A0000251，Name＝社交场-2，Text内容片段＝“……同时也把一张有品位的餐桌推向了全欧洲，……”

SQL语句如下：
select a.asset_code, a.asset_name, a.state_id
from assets as a,
(select asset_id
from asset_content
where freetext(*, '品位')
) ta
where a.asset_id = ta.asset_id
order by 3 desc, 1

但是，查询条件＝“品”，在结果中看不到该记录。

这样的情况还有很多，或者是我们使用方法错误。请指教

Best Regard，

YuQ

Reply to this Message

Hilary Cotter - 18 Apr 2008 04:03 GMT

use contains

select a.asset_code, a.asset_name, a.state_id
from assets as a,
(select asset_id
from asset_content
where CONTAINS(*, 'Æ·Î»')
) ta
where a.asset_id = ta.asset_id
order by 3 desc, 1

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Dears£¬

ÎÒÃÇÔÚÊ¹ÓÃMS SQL ServerÈ«ÎÄ¼ìË÷Ê±£¬Åöµ½ÈçÏÂÎÊÌâ£¬Çë¸÷Î»´óÏÀ½âÊÍÒ»ÏÂÔÒò¡£

ÎÒÃÇ·Ö±ðÓÃ¡°Æ·Î»¡±ºÍ¡°Æ·¡±²éÑ¯Ä³¸ötextÊý¾ÝÀàÐÍ£¬·¢ÏÖ½á¹ûºÜÆæ¹Ö¡£

²éÑ¯Ìõ¼þ£½¡°Æ·Î»¡±£¬ÔÚ½á¹ûÖÐ¿´µ½¸ÃÒ»±Ê¼ÇÂ¼ÈçÏÂ£º
Code£½A0000251£¬Name£½Éç½»³¡-2£¬TextÄÚÈÝÆ¬¶Î£½¡°¡¡Í¬Ê±Ò²°ÑÒ»ÕÅÓÐÆ·Î»µÄ²Í×ÀÍÆÏòÁËÈ«Å·ÖÞ£¬¡¡¡±

SQLÓï¾äÈçÏÂ£º
select a.asset_code, a.asset_name, a.state_id
from assets as a,
(select asset_id
from asset_content
where freetext(*, 'Æ·Î»')
) ta
where a.asset_id = ta.asset_id
order by 3 desc, 1

µ«ÊÇ£¬²éÑ¯Ìõ¼þ£½¡°Æ·¡±£¬ÔÚ½á¹ûÖÐ¿´²»µ½¸Ã¼ÇÂ¼¡£

ÕâÑùµÄÇé¿ö»¹ÓÐºÜ¶à£¬»òÕßÊÇÎÒÃÇÊ¹ÓÃ·½·¨´íÎó¡£ÇëÖ¸½Ì

Best Regard£¬

YuQ

Reply to this Message