Search for keyword match using FULLTEXT

QueryStash

Search for keyword match using FULLTEXT

This query creates a table with a FULLTEXT field to allow for text search of a given field. The SELECT statement uses MATCH and AGAINST to look for the search text in the title and description. Search words are separated by spaces, no commas.

1CREATE TABLE IF NOT EXISTS testTable (
2  id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
3  title VARCHAR(64),
4  description TEXT,
5  FULLTEXT (title, description)
6 );
7 
8 SELECT * FROM testTable MATCH (title, description) AGAINST ('<SEARCHTEXT>')

CREATE TABLE IF NOT EXISTS testTable (
  id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(64),
  description TEXT,
  FULLTEXT (title, description)
 );
 
 SELECT * FROM testTable MATCH (title, description) AGAINST ('<SEARCHTEXT>')

Public

mysql

Benny G

Created: Jun 27th 2022

QueryStash

Made with ❤️ by @Yekalb

Twitter Facebook Email

Resources

Blog Pricing Your First Query Search Your Stash

Examples

Merge Statements Persistent Functions Spike Detection QUALIFY Statement BigQuery ML Models

Stay up to date