Search Result: butter - DuckDB 2.0 全文検索

Full-Text Search 9414: DuckDB supports full-text search via the fts extension . A full-text index allows for a query to quickly search for all occurrences of individual words within longer text strings. Example: Shakespeare Corpus Here's an example of building a ... dy to query using the Okapi BM25 ranking function. Rows with no match return a NULL score. What does Shakespeare say about butter? SELECT * FROM ( SELECT fts_main_corpus.match_bm25(line_id, 'butter') AS score, line_id, play_name, speaker, text_entry FR ... LL ORDER BY score DESC; score line_id play_name speaker text_entry 4.427313429798464 H4/2.4.494 Henry IV Carrier As fat as butter. 3.836270302568675 H4/1.2.21 Henry IV FALSTAFF prologue to an egg and butter. 3.836270302568675 H4/2.1.55 Henry IV Chamber ... lain They are up already, and call for eggs and butter; 3.3844488405497115 H4/4.2.21 Henry IV FALSTAFF toasts-and-butter, with hearts in their bellies no 3.3844488405497115 H4/4 ...; https://man.mtool.work/duckdb/2.0/guides/sql_features/full_text_search.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work