SupabaseS
Supabase12mo ago
FsFsmk

text search and ilike not working for partial or similar text

i am trying to fuzzily match a string from the db so i looked in the docs and found ilike and text_search so i did this:
async def search(cls, query: str) -> list:
    """Searches the database for rows that match the query."""
    await cls.setup()
    response: APIResponse = await (
        cls.__new__(cls).table("test_table").select("*").text_search("test_column", query).execute()
    )
    return response.data


and queried eggs while one of the column values is egg(that specifically is said to work in the docs) but got an empty list, how exactly do i get it to work?
Was this page helpful?