Results of 1 - 1 of about 1 for speaker (0.000 sec.)
- 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
...fault extra line_id VARCHAR YES NULL NULL NULL play_name VARCHAR YES NULL NULL NULL line_number VARCHAR YES NULL NULL NULL speaker VARCHAR YES NULL NULL NULL text_entry VARCHAR YES NULL NULL NULL The text of each line is in text_entry , and a unique key...peare say about butter? SELECT * FROM ( SELECT fts_main_corpus.match_bm25(line_id, 'butter') AS score, line_id, play_name, speaker, text_entry FROM corpus ) sq WHERE score IS NOT NULL ORDER BY score DESC; score line_id play_name speaker text_entry 4.427...g a Shakespeare corpus for full-text searching from JSON” blog post . The Columns are: line_id , play_name , line_number , speaker , text_entry . We need a unique key for each row in order for full-text searching to work. The line_id KL/2.4.132 means Ki... - https://man.mtool.work/duckdb/2.0/guides/sql_features/full_text_search.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work