Databases Reference
In-Depth Information
The above did not find lines with the word "codes". Why? This is because Soundex
code unconditionally starts from the first letter of the word, not a mapped letter. We
can see it in MySQL:
mysql> select soundex('codes'),soundex('kodezz');
+------------------+------------------+
| soundex('codes') | soundex('kodez') |
+------------------+------------------+
| C320 | K320 |
+------------------+------------------+
1 row in set (0.00 sec)
Using a more complex phonetic algorithm, for example,
Metaphone
, would solve this
particular problem; Metaphone code for both "Codes" and "Kodezz" is KTS.
Summary
In this chapter we have learned how to write parsers that support searches in
Boolean mode. We have developed three parser plugins that show different ways
of using a full-text parser plugin API—"extractor", "tokenizer", and "post-processor"
approaches. We have seen how full-text parser plugins can be used to implement
searches within image metadata, and how to create search-enabled applications that
are insensitive to typos and misspelled words.
This chapter is the last one dedicated to full-text parser plugins. The next chapter
starts with the topic of the most complex and broad MySQL plugin type of all—the
Storage Engine plugins.
