Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
With this modifier, certain characters have special meaning at the beginning or end of words in the search string. | +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...In the following query, the + and - operators ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-table-search.html
Find data across a MySQL connection by using the text search feature on any number of tables and schemas. From the schema tree, select the tables, schemas, or both to search and then right-click the highlighted items and click Search Data Table ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
This causes no additional overhead, because the MySQL optimizer notices that the two MATCH() calls are identical and invokes the full-text search code only once. MyISAM Limitation For very small tables, word distribution does not adequately reflect ... By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-adding-module-search-paths.html
When you use the require() function in JavaScript or the import function in Python, the module search paths listed for the sys.path variable are used to search for the specified module. MySQL Shell initializes the sys.path variable to contain the ...For JavaScript, the subfolder share/mysqlsh/modules/js of the MySQL Shell home folder, or the subfolder /modules/js of the folder containing the mysqlsh binary, if the home folder is not ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. This function serves as counterpart to ...
https://dev.mysql.com/doc/internals/en/full-text-search.html
If MySQL was a search engine and there was no need to update in real time, this tricky part wouldn't matter. The value of thinking of it this way is: once you realize that term occurrences are lines in a multi-dimensional space, you can apply basic ... MySQL uses Ranking with Vector Spaces for ordinary full-text ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-search.html
The topics in this section describe how to perform RAG with vector search. When you enter a query, MySQL HeatWave GenAI performs a vector-based similarity search to retrieve similar content from the vector store and embedding tables available in ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-row-searches.html
The algorithm used to carry out this process uses one of the table's indexes to carry out the search as the first choice, and a hash table if there are no suitable indexes. When a replica using row-based replication format applies an UPDATE or ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-vector-search.html
The topics in this section describe how to perform RAG with vector search. When you enter a query, GenAI performs a vector-based similarity search to retrieve similar content from the vector store and embedding tables available in the DB system.