-- 检查是否已创建全文索引
SHOW INDEX FROM your_table WHERE Index_type = 'FULLTEXT';

-- 创建全文索引
ALTER TABLE your_table ADD FULLTEXT(your_column);

-- 使用正确的查询语法
SELECT * FROM your_table 
WHERE MATCH(your_column) AGAINST('search term' IN NATURAL LANGUAGE MODE);

// 检查索引是否存在
GET /_cat/indices?v

// 创建索引并定义映射
PUT /your_index
{
  "mappings": {
    "properties": {
      "content": {
        "type": "text",
        "analyzer": "standard"
      }
    }
  }
}

// 执行搜索查询
GET /your_index/_search
{
  "query": {
    "match": {
      "content": "search term"
    }
  }
}

import whoosh.index as index
from whoosh.qparser import QueryParser

# 检查索引是否存在
if not index.exists_in("indexdir"):
    # 创建索引
    schema = Schema(title=TEXT(stored=True), content=TEXT)
    ix = index.create_in("indexdir", schema)
else:
    ix = index.open_dir("indexdir")

# 执行搜索
with ix.searcher() as searcher:
    query = QueryParser("content", ix.schema).parse("search term")
    results = searcher.search(query)
    for hit in results:
        print(hit["title"])