mysql全文检索查询错误

Question

在表中给字段uname, mobile, email, tname, user_no创建全文索引，输入邮箱号“[e-mail]”进行查询。
使用布尔值模式进行全文检索，最后查询无结果

SELECT
u.id,u.user_no as userNo,u.uname,u.mobile,u.email,u.tname,u.regtime,u.flag
FROM lb_user u
WHERE MATCH (uname, mobile, email, tname, user_no)
AGAINST('+ce111111111111 +sina11111.com' in boolean mode)
order by u.id desc

若输入：[e-mail]进行查询则能查询结果：

SELECT
u.id,u.user_no as userNo,u.uname,u.mobile,u.email,u.tname,u.regtime,u.flag
FROM lb_user u
WHERE MATCH (uname, mobile, email, tname, user_no)
AGAINST('+ce111111111111 +sina11111.co' in boolean mode)
order by u.id desc

Answer 1

http://blog.csdn.net/u011734144/article/details/52817766