---
title: "💭 Full-text search - Datasette documentation"
description: "!https://docs.datasette.io/en/latest/full_search.html#enabling-full-text-search-for-a-sqlite-table"
date: 2023-07-28
published: true
tags:
  - sqlite
  - data
  - database
  - thought
template: link
---


<div class="embed-card embed-card-external">
  <a href="https://docs.datasette.io/en/latest/full_text_search.html#enabling-full-text-search-for-a-sqlite-table" class="embed-card-link" target="_blank" rel="noopener noreferrer">
    <div class="embed-card-content">
      <div class="embed-card-title">Full-text search - Datasette documentation</div>
      <div class="embed-card-meta">docs.datasette.io</div>
    </div>
  </a>
</div>


Enable full-text search in sqlite using sqlite-utils.

``` bash
$ sqlite-utils enable-fts mydatabase.db items name description
```

!!! note

    This post is a <a href="/thoughts/" class="wikilink" data-title="Thoughts" data-description="These are generally my thoughts on a web page or some sort of url, except a rare few don&#39;t have a link. These are dual published off of my..." data-date="2024-04-01">thought</a>. It's a short note that I make
    about someone else's content online <a href="/tags/thoughts/" class="hashtag-tag" data-tag="thoughts" data-count=2 data-reading-time=3 data-reading-time-text="3 minutes">#thoughts</a>