June 2005
Intermediate
720 pages
20h 6m
English
In Chapter 4, the LIKE keyword was introduced as a way to perform somewhat simple string matches like
SELECT * FROM users WHERE last_name → LIKE 'Smith%'
This type of conditional is effective enough but is still very limiting. For example, it would not allow you to do Google-like searches using multiple words. For those kinds of situations, you need FULLTEXT searches.
FULLTEXT searches require a FULLTEXT index, which you’ll create next. Then you’ll learn the special SQL syntax for performing these searches. Finally, you’ll read about some capabilities added in MySQL 4.0.1 to make your FULLTEXT searches more exacting.
The FULLTEXT index is just a special type of index necessary to run ...
Read now
Unlock full access