Full-Text Search syntax : MATCH « FullText Search « SQL / MySQL






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

Full-Text Search syntax

      

For a full-text search, the SQL expression MATCH AGAINST is used:


SELECT * FROM tablename
WHERE MATCH(column1, column2) AGAINST('word1 word2 word3') > 0.001;








Related examples in the same category

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.