Boolean Search Expressions (IN BOOLEAN MODE) : Boolean Search « FullText Search « SQL / MySQL






  1. SQL / MySQL
  2. FullText Search
  3. Boolean Search

Boolean Search Expressions (IN BOOLEAN MODE)

     

+word               The word must be contained.
-word               The word may not appear.

~word               The word should not appear in the record. 
                    Thus ~word is suited to eliminate "noise words".


<word               Gives the word a lesser standing.
>word               Gives the word a greater standing.
word*               Searches for words that begin with word (e.g., word, words, wordless).
"word1 word2"       This exact word order should be searched. Case-insensitive.
()                  Used to group expressions. 

A Boolean full-text search might look like this:

SELECT * FROM tablename
WHERE MATCH(column1, column2)
AGAINST('+word1 +word2 -word3' IN BOOLEAN MODE)








Related examples in the same category

1.Overview of Boolean Search Operators
2.Precede each word in the search string with a + character and add IN BOOLEAN MODE after the string
3.Boolean mode searches also allow you to exclude words.
4.FULLTEXT searching supports phrase searching in Boolean mode.
5.In boolean mode
6.Quotation in boolean mode
7.* in boolean mode
8.Boolean Full-Text Searches