提问者:小点点

如何优化MySQL的全文搜索以匹配类似'C++'的字符串


我们在自然语言模式下使用MySQL的全文搜索,但是搜索不匹配像'C++'这样的术语。 我们如何优化mysql,使其在全文搜索中正确匹配,并且不删除特殊字符? 当然,像逗号这样的字符仍然应该被删除。


共1个答案

匿名用户

如果我理解了您的问题,您可以声明使代码易于阅读的定义,例如:

#define INSERT_INTO "INSERT INTO "
#define DELETE "DELETE "
#define VALUES "VALUES ( "
#define AND " AND "
#define JOIN "JOIN "
#define EQUAL "= "
#define LIKE " LIKE "
#define ORDER_BY "ORDER BY "
#define LIMIT "LIMIT "
#define SELECT "SELECT "
#define ALL "* "
#define FROM "FROM "
#define END_STATEMENT ";"
#define WHERE "WHERE "
#define SELECT_TRUE_FROM "SELECT 1 FROM " 

相关问题


MySQL Query : SELECT * FROM v9_ask_question WHERE 1=1 AND question regexp '(优化|mysql|全文|搜索|匹配|类似|c++|字符串)' ORDER BY qid DESC LIMIT 20
MySQL Error : Got error 'repetition-operator operand invalid' from regexp
MySQL Errno : 1139
Message : Got error 'repetition-operator operand invalid' from regexp
Need Help?