MATCH « FullText Search « SQL / MySQL






  1. SQL / MySQL
  2. FullText Search
  3. MATCH
1.A MATCH expression for fulltext search can be used to order results.
2.Use MATCH in where statement
3.MATCH(TITLE) AGAINST ('to')
4.Using match in where clause
5.Using match in select statement
6.Using the same match...against clause in select clause and where clause
7.Matches two words
8.Matches two columns
9.Matches two columns in boolean mode




10.Match two words in boolean mode
11.Match against a long sentence
12.Get the numbers and relevance values of the books in which distributed appears in the summary.
13.Get the numbers and titles of the books in which database appears in the title.
14.Get the numbers and titles of the books in which the phrase design implementation appears.
15.You can include additional criteria to narrow the search further.
16.Full-Text Search syntax