How to allow fulltext searching with hyphens in the search query

by

From here http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

One solution to find a word with a dashes or hyphens in is to use FULL TEXT SEARCH IN BOOLEAN MODE, and to enclose the word with the hyphen / dash in double quotes.

Or from here http://bugs.mysql.com/bug.php?id=2095

There is another workaround. It was recently added to the manual:
”
Modify a character set file: This requires no recompilation. The true_word_char() macro
uses a “character type” table to distinguish letters and numbers from other
characters. . You can edit the contents in one of the character set XML
files to specify that ‘-‘ is a “letter.” Then use the given character set for your
FULLTEXT indexes.
“

Have not tried it on my own.

Edit: Here is some more additional info from here http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html

A phrase that is enclosed within double quote (“””) characters matches only rows that contain the phrase literally, as it was typed. The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. Prior to MySQL 5.0.3, the engine then performed a substring search for the phrase in the records that were found, so the match must include nonword characters in the phrase. As of MySQL 5.0.3, nonword characters need not be matched exactly: Phrase searching requires only that matches contain exactly the same words as the phrase and in the same order. For example, “test phrase” matches “test, phrase” in MySQL 5.0.3, but not before.

If the phrase contains no words that are in the index, the result is empty. For example, if all words are either stopwords or shorter than the minimum length of indexed words, the result is empty.

More Related Contents:

  1. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  2. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  3. Implementation of Levenshtein distance for mysql/fuzzy search?
  4. Search for “whole word match” in MySQL
  5. MySQL find_in_set with multiple search string
  6. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  7. MySQL match() against() – order by relevance and column?
  8. Fulltext Search with InnoDB
  9. MySQL search and replace some text in a field
  10. mysql fulltext search failure
  11. How to escape literal percent sign when NO_BACKSLASH_ESCAPES option is enabled?
  12. Search for string within text column in MySQL
  13. Search all columns of a table using a single where condition with single keyword in mysql
  14. SQL search multiple values in same field
  15. Django MySQL full text search
  16. Accent insensitive search query in MySQL
  17. MySQL Fulltext Search Score Explained
  18. Laravel – search with multiple keywords against multiple columns with the search result to be ordered in relevance
  19. If two columns are 1 then make new column
  20. Can we use CONCAT and JOIN together in MySQL? [closed]
  21. Retrieving the last record in each group – MySQL
  22. Find distance between two points using latitude and longitude in mysql
  23. CROSS/OUTER APPLY in MySQL
  24. Solution to “subquery returns more than 1 row” error
  25. Storing SHA1 hash values in MySQL
  26. Downloading MySQL dump from command line
  27. DOUBLE vs DECIMAL in MySQL
  28. ColdFusion Parameterizing a Query
  29. How to select the first row for each group in MySQL?
  30. What to do when you need integers larger than 20 digits on mysql?

Leave a Comment