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
Note
Not All Engines Support Full-Text Searching. As 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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.