MySQL Boolean Full-Text Search

Submitted by:David Villa

Date added:16 January, 2012

Category:MySQL

MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier with MATCH function

Tags: boolean full-text search

Code Snippet:

SELECT id, text, MATCH (text) AGAINST ('word')
AS score FROM table1
WHERE MATCH (text) AGAINST ('word' in boolean mode) order by score desc;
 
 

Comments