Full-Text Search in SingleStoreDB

SingleStoreDB is a real-time, distributed SQL database that supports both transactional and analytical workloads in a single unified database. It integrates full-text search capabilities into its core functionality, simplifying the data landscape by not requiring specialty databases for this purpose. Full-text searches allow users to search text inside text data stored in a table, returning results with some or all of the words from the query. The database supports various operators in the expression used in the MATCH AGAINST function, such as +, -, *, ?, and ~, which can be used to perform exact, fuzzy, or wildcard searches. SingleStoreDB's patented Universal Storage enables fast scans of individual columns, making it ideal for columnstore tables with full-text indexes. The database provides examples, including creating a full-text index and performing searches using the MATCH AGAINST function, as well as combining aggregation queries with full-text search to find top values.