+ 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.