MATCH()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
A description for this Function has not yet been added to this Documentation.
EXAMPLES
CREATE TABLE t (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
subj TEXT,
FULLTEXT (title,subj)
);
INSERT INTO t (title,subj) VALUES
('MariaDB Intro','MariaDB is a relational database'),
('MariaDB Unique','MariaDB supports Column Store'),
('MariaDB storage engine','MariaDB default storage engine is InnoDB');
SELECT * FROM t
WHERE MATCH (title,subj)
AGAINST ('MariaDB' IN NATURAL LANGUAGE MODE);
+----+------------------------+------------------------------------------+
| id | title | subj |
+----+------------------------+------------------------------------------+
| 1 | MariaDB Intro | MariaDB is a relational database |
| 2 | MariaDB Unique | MariaDB supports Column Store |
| 3 | MariaDB storage engine | MariaDB default storage engine is InnoDB |
+----+------------------------+------------------------------------------+
SELECT *
FROM t
WHERE MATCH (title,subj) AGAINST ('+MariaDB -InnoDB' IN BOOLEAN MODE);
+----+----------------+----------------------------------+
| id | title | subj |
+----+----------------+----------------------------------+
| 1 | MariaDB Intro | MariaDB is a relational database |
| 2 | MariaDB Unique | MariaDB supports Column Store |
+----+----------------+----------------------------------+
SELECT *
FROM t
WHERE MATCH (title,subj) AGAINST ('storage' WITH QUERY EXPANSION);
+----+------------------------+------------------------------------------+
| id | title | subj |
+----+------------------------+------------------------------------------+
| 3 | MariaDB storage engine | MariaDB default storage engine is InnoDB |
| 1 | MariaDB Intro | MariaDB is a relational database |
| 2 | MariaDB Unique | MariaDB supports Column Store |
+----+------------------------+------------------------------------------+