Chapter 18. Full-Text Searching

In this chapter, you’ll learn how to use MySQL’s full-text searching capabilities to perform sophisticated data querying and selection.

Understanding Full-Text Searching


Not All Engines Support Full-Text SearchingAs will be explained in Chapter 21, “Creating and Manipulating Tables,” MySQL supports the use of several underlying database engines. Not all engines support full-text searching as is described in this chapter. The two most commonly used engines are MyISAM and InnoDB; the former supports full-text searching and the latter does not. This is why, although most of the sample tables used in this book were created to use InnoDB, one (the productnotes table) was created to use MyISAM. If you need full-text ...

Get MySQL® Crash Course now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.