Home arrow MySQL arrow Using Boolean Operators for Full Text and Boolean Searches with MySQL

Using Boolean Operators for Full Text and Boolean Searches with MySQL

Implementing full text searches with MySQL can improve the execution of queries against specific database tables. If you want to put this useful feature to work for you, start reading this article now! Welcome to the final tutorial of the series that began with "Performing Full Text and Boolean Searches with MySQL." Made up of three tutorials, this series walks you through the basics of creating full text indexes in MySQL tables, and shows you how to take advantage of Boolean searches to improve the performance of your SQL queries.

  1. Using Boolean Operators for Full Text and Boolean Searches with MySQL
  2. Reintroducing some earlier concepts
  3. Using the plus operator
  4. Using the minus operator
By: Alejandro Gervasio
Rating: starstarstarstarstar / 8
June 20, 2007

print this article




As you'll probably remember, in the previous article of the series I discussed in detail some crucial topics surrounding the implementation of full text searches using MySQL. Specifically, I covered the use of the MATCH and AGAINST statements, which when used in conjunction allow us to retrieve easily not only database results, but also different relevance rankings, depending on the terms included into a given search string.

Of course, I accompanied the discussion with numerous code samples, which hopefully helped you to grasp more easily how MySQL-based full text searches can be implemented in real-world situations. Certainly, analyzing the subject from a completely practical point of view implies that many web developers can have at their disposal a decent variety of hands-on examples to help them start rapidly incorporating these useful features into their MySQL-driven applications.

Nonetheless, I have to admit that full text searches and MySQL is a huge topic, which possibly deserves many more articles than the ones I wrote for the excellent Developer Shed network. But this doesn't prevent me from making my humble contribution to the subject. So in this last installment of the series I'm going to dive a bit deeper into the area of using full text searches with MySQL by showing you how to use the popular Boolean operators to add (and discard) specific terms from a given search string.

Are you ready to learn how to incorporate Boolean search capabilities to your web applications? Let's begin now!

>>> More MySQL Articles          >>> More By Alejandro Gervasio

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: