I am using a keyword like 'iphone 6 plus' or anything including 'plus' keyword for mysql full text searching on my local database, but its return empty result.
我正在使用一个关键字，比如“iphone 6 plus”或任何包含“plus”关键字的mysql全文搜索，在我的本地数据库，但它返回空结果。
Its only for plus keyword cause when i was using a query like match('keyword_map') against ('plus' IN BOOLEAN MODE).
它只适用于plus关键字，因为我在布尔模式下使用match('keyword_map')和'plus'之类的查询。
This query returns empty result.There is a lot of data stored in my database with plus keyword. When i use mysql like search its working. Please anybody give me solution for that.
该查询返回空结果。我的数据库中有很多数据是用plus关键字存储的。当我用mysql搜索时。请大家给我解答。
2 个解决方案
#1
2
Plus is mysql reserved keyword. there is also another keyword like
Plus是mysql保留关键字。还有另外一个关键字like
ACCESSIBLE (R) ACTION ADD (R) AFTER AGAINST AGGREGATE ALGORITHM ALL (R) ALTER (R) ANALYZE (R) AND (R) ANY AS (R) ASC (R) ASCII ASENSITIVE (R) AT AUTHORS AUTOEXTEND_SIZE AUTO_INCREMENT AVG AVG_ROW_LENGTH BACKUP BEFORE (R) BEGIN BETWEEN (R) BIGINT (R) BINARY (R) BINLOG BIT BLOB (R) BLOCK BOOL BOOLEAN BOTH (R) BTREE BY (R) BYTE CACHE CALL (R) CASCADE (R) CASCADED CASE (R) CATALOG_NAME CHAIN CHANGE (R) CHANGED CHAR (R) CHARACTER (R) CHARSET CHECK (R) CHECKSUM CIPHER CLASS_ORIGIN CLIENT CLOSE COALESCE CODE COLLATE (R) COLLATION COLUMN (R) COLUMNS COLUMN_NAME COMMENT COMMIT COMMITTED COMPACT COMPLETION COMPRESSED CONCURRENT CONDITION (R) CONNECTION CONSISTENT CONSTRAINT (R) CONSTRAINT_CATALOG CONSTRAINT_NAME CONSTRAINT_SCHEMA CONTAINS CONTEXT CONTINUE (R) CONTRIBUTORS CONVERT (R) CPU CREATE (R) CROSS (R) CUBE CURRENT_DATE (R) CURRENT_TIME (R) https://dev.mysql.com/doc/refman/5.5/en/keywords.html
访问(R)行动之后添加(R)与聚合算法所有(R)改变(R)分析(R)和(R)(R)ASC(R)ASCII ASENSITIVE(R)在作者AUTOEXTEND_SIZE AUTO_INCREMENT AVG AVG_ROW_LENGTH备份(R)开始之前(R)之间的BIGINT(R)二进制(R)BINLOG一点BLOB(R)块BOOL布尔(R)BTREE(R)字节缓存调用(R)级联(R)级联情况下(R)CATALOG_NAME链变化(R)改变CHAR(R)字符(R)字符集(R)校验和检查密码CLASS_ORIGIN客户关闭合并代码COLLATE (R) COLLATION列(R)列COLUMN_NAME注释提交已提交的紧凑完成压缩并发条件(R)连接一致约束(R) CONSTRAINT_CATALOG CONSTRAINT_SCHEMA包含上下文CONTINUE (R)贡献者转换(R) CPU创建(R) CROSS (R)立方体CURRENT_DATE (R) CURRENT_DATE (R) https://dev.mysql.com/doc/refman/5.5/en/keywords.html。
#2
0
Plus is mysql reserved keyword thats why plus is not working in mysql match against search.
Plus是mysql保留的关键字，这就是为什么Plus不支持mysql匹配搜索的原因。
#1
2
Plus is mysql reserved keyword. there is also another keyword like
Plus是mysql保留关键字。还有另外一个关键字like
ACCESSIBLE (R) ACTION ADD (R) AFTER AGAINST AGGREGATE ALGORITHM ALL (R) ALTER (R) ANALYZE (R) AND (R) ANY AS (R) ASC (R) ASCII ASENSITIVE (R) AT AUTHORS AUTOEXTEND_SIZE AUTO_INCREMENT AVG AVG_ROW_LENGTH BACKUP BEFORE (R) BEGIN BETWEEN (R) BIGINT (R) BINARY (R) BINLOG BIT BLOB (R) BLOCK BOOL BOOLEAN BOTH (R) BTREE BY (R) BYTE CACHE CALL (R) CASCADE (R) CASCADED CASE (R) CATALOG_NAME CHAIN CHANGE (R) CHANGED CHAR (R) CHARACTER (R) CHARSET CHECK (R) CHECKSUM CIPHER CLASS_ORIGIN CLIENT CLOSE COALESCE CODE COLLATE (R) COLLATION COLUMN (R) COLUMNS COLUMN_NAME COMMENT COMMIT COMMITTED COMPACT COMPLETION COMPRESSED CONCURRENT CONDITION (R) CONNECTION CONSISTENT CONSTRAINT (R) CONSTRAINT_CATALOG CONSTRAINT_NAME CONSTRAINT_SCHEMA CONTAINS CONTEXT CONTINUE (R) CONTRIBUTORS CONVERT (R) CPU CREATE (R) CROSS (R) CUBE CURRENT_DATE (R) CURRENT_TIME (R) https://dev.mysql.com/doc/refman/5.5/en/keywords.html
访问(R)行动之后添加(R)与聚合算法所有(R)改变(R)分析(R)和(R)(R)ASC(R)ASCII ASENSITIVE(R)在作者AUTOEXTEND_SIZE AUTO_INCREMENT AVG AVG_ROW_LENGTH备份(R)开始之前(R)之间的BIGINT(R)二进制(R)BINLOG一点BLOB(R)块BOOL布尔(R)BTREE(R)字节缓存调用(R)级联(R)级联情况下(R)CATALOG_NAME链变化(R)改变CHAR(R)字符(R)字符集(R)校验和检查密码CLASS_ORIGIN客户关闭合并代码COLLATE (R) COLLATION列(R)列COLUMN_NAME注释提交已提交的紧凑完成压缩并发条件(R)连接一致约束(R) CONSTRAINT_CATALOG CONSTRAINT_SCHEMA包含上下文CONTINUE (R)贡献者转换(R) CPU创建(R) CROSS (R)立方体CURRENT_DATE (R) CURRENT_DATE (R) https://dev.mysql.com/doc/refman/5.5/en/keywords.html。
#2
0
Plus is mysql reserved keyword thats why plus is not working in mysql match against search.
Plus是mysql保留的关键字，这就是为什么Plus不支持mysql匹配搜索的原因。