Full Text Search Function
In mysql, we have search the keywords in fields using Full-Text Search functions. We can perform boolean full-text searches using the IN BOOLEAN MODE modifier
Syntax:
SELECT [fields] FROM [table_name] WHERE MATCH ([fields]) AGAINST (’[keyword]’ IN BOOLEAN MODE);
Example:
SELECT id from site_table where match (url) againt (’html’ IN BOOLEAN MODE)
