MYSQL match against 疑义
Jun 13, 2016 am 11:12 AM
MYSQL match against 疑问
-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2013 年 01 月 21 日 03:14
-- 服务器版本: 5.0.45
-- PHP 版本: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 数据库: `test`
--
-- --------------------
--
-- 表的结构 `city`
--
CREATE TABLE `city` (
`city_id` int(11) NOT NULL auto_increment,
`city` varchar(50) NOT NULL,
`pos` varchar(50) NOT NULL,
`level` tinyint(4) NOT NULL,
PRIMARY KEY (`city_id`),
FULLTEXT KEY `city` (`city`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=11 ;
--
-- 导出表中的数据 `city`
--
INSERT INTO `city` VALUES (1, '中国', '1', 1);
INSERT INTO `city` VALUES (2, '广州天河区', '1,2', 2);
INSERT INTO `city` VALUES (3, '深圳', '1,3', 2);
INSERT INTO `city` VALUES (4, '宝安', '1,3,4', 3);
INSERT INTO `city` VALUES (5, '南头', '1,3,5', 3);
INSERT INTO `city` VALUES (6, '福田', '1,3,6', 3);
INSERT INTO `city` VALUES (7, '天河', '1,2,7', 3);
INSERT INTO `city` VALUES (8, '沙河', '1,2,7,8', 4);
INSERT INTO `city` VALUES (9, '沙河', '1,2,7,9', 4);
INSERT INTO `city` VALUES (10, 'hello world my friend', '', 0);
SELECT *
FROM `city`
WHERE MATCH (
`city`
)
AGAINST (
'hello'
)
上述sql 匹配不了city_id为10的记录 为什么呢? 匹配 AGAINST ('world') 就可以,应该不是长度问题。 求助大神,先谢谢啦!!!
------解决方案--------------------
1、全文检索会忽略掉一些语气词、问候词。因为他们出现的太频繁,却又无法缩小搜索的范围
2、mysql 的全文检索不支持宽字符集,因此你的测试并无实际意义
------解决方案--------------------
hello是stop word所以搜不到
http://dev.mysql.com/doc/refman/5.5/en/fulltext-stopwords.html

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Solution: Your organization requires you to change your PIN

How to adjust window border settings on Windows 11: Change color and size

How to change title bar color on Windows 11?

How to enable or disable taskbar thumbnail previews on Windows 11

OOBELANGUAGE Error Problems in Windows 11/10 Repair

10 Ways to Adjust Brightness on Windows 11

How to turn off private browsing authentication for iPhone in Safari?
