mysql全文检索查询错误

在表中给字段uname, mobile, email, tname, user_no创建全文索引,输入邮箱号“ce111111111111@sina11111.com”进行查询。
使用布尔值模式进行全文检索,最后查询无结果
图片说明
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

若输入:ce111111111111@sina11111.co进行查询则能查询结果:
图片说明
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

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