注册 登录
编程论坛 MySQL论坛

mysql全文搜索问题-->千里冰封转移

想你的天空 发布于 2006-11-06 18:37, 1657 次点击
CREATE PROCEDURE `keyToSearch`(in searchKey varchar(100))
begin
declare keyStr varchar(100);
set keyStr = searchKey;
SELECT id, title,content, MATCH (title,content) AGAINST
(keyStr) AS score
FROM generalmessage WHERE MATCH (title,content) AGAINST
(keyStr);
end;

查询到0条记录, 怎么办啊????
1 回复
#2
棉花糖ONE2006-11-13 13:23
你的全文索引建了吗.还有数据中是不是存在那些关键字的记录
1