Summary of Search Operators

The + and - operators indicate that a word is required to be present or absent, respectively, for a match to occur. Thus, this query retrieves all the rows that contain the word MySQL but that do not contain the word YourSQL.

The boolean full-text search capability supports the following operators:

The following examples demonstrate some search strings that use boolean full-text operators: