sections: full_text_search:configuring-fts-using-sqlite-utils

This data as json

id	page	ref	title	content	breadcrumbs	references
full_text_search:configuring-fts-using-sqlite-utils	full_text_search	configuring-fts-using-sqlite-utils	Configuring FTS using sqlite-utils	sqlite-utils is a CLI utility and Python library for manipulating SQLite databases. You can use it from Python code to configure FTS search, or you can achieve the same goal using the accompanying command-line tool . Here's how to use sqlite-utils to enable full-text search for an items table across the name and description columns: sqlite-utils enable-fts mydatabase.db items name description	["Full-text search", "Enabling full-text search for a SQLite table"]	[{"href": "https://sqlite-utils.datasette.io/", "label": "sqlite-utils"}, {"href": "https://sqlite-utils.datasette.io/en/latest/python-api.html#enabling-full-text-search", "label": "it from Python code"}, {"href": "https://sqlite-utils.datasette.io/en/latest/cli.html#configuring-full-text-search", "label": "using the accompanying command-line tool"}]