Close this window

Boolean Full-Text Search Mode Operators

+   A leading plus sign indicates that this word must be present in every record returned.

-    A leading minus sign indicates that this word must not be present in any record returned.

*   An asterisk is the truncation operator. Unlike the other operators, it is appended to the word, or fragment, not prepended.

"  "    Double quotes at the beginning and end of a phrase, matches only records that contain the complete phrase, as it was typed.

(From the MySQL Manual)

Boolean Full-Text Search Examples

Roy Boucher   --> Find all the cemetery headstone records that contain either Roy or Boucher as a last name. Each resulting record will all have at least one of the two names in it.

+Lizotte +Cyr   --> Find all the cemetery headstone records that contain both Lizotte and Cyr names. Each resulting record will include both words.

+Lizotte -Cyr   --> Find cemetery headstone records that contain the name "Lizotte'' but not the name "Cyr''.

Bou*   --> Find cemetery headstone that contain the name "Bouchard'', "Boucher'', or "Bourgoin''.

"Levesque Jr"   --> Find all the cemetery headstone records that contain the last name "Levesque Jr but not those with a name of Levesque only.

Close this window