This mode allows you to search words based on AND/OR criteria, such as ???+beautiful +flower???,
which retrieves all the rows that contain both the words ???beautiful??? and ???flower???.
??? Faster searches are possible. Because of the use of the special search indexes, the search
operation is much faster than when using the LIKE method.
?– Tip Learn more about the full-text searching capabilities of MySQL at http://dev.mysql.com/doc/
refman/5.1/en/fulltext-search.html.
As explained in Chapter 4, the main disadvantage of the full-text search feature is that it
only works with the MyISAM table type. The alternative table type you could use is InnoDB,
which is more advanced and supports features such as foreign keys, ACID transactions, and
more but doesn??™t support the full-text feature.
CHAPTER 8 ?– SEARCHING THE CATALOG 225
?– Note ACID is an acronym that describes the four essential properties for database transactions: Atomicity,
Consistency, Isolation, and Durability.We won??™t use database transactions in this book, but you can learn more
about them from other sources, such as The Programmer??™s Guide to SQL(Apress, 2003). The database transactions
chapter of that book can be downloaded freely from http://www.cristiandarie.ro/downloads/.
In the following few pages, you??™ll first create FULLTEXT indexes in your database and then
learn how to use them to search your catalog.
Pages:
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336