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

ilike

ilike

ilike and

text_search

text_search

text_search

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

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

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

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

eggs

eggs

eggs while one of the column values is

egg

egg

egg

egg(that specifically is said to work in the docs) but got an empty list, how exactly do i get it to work?

text search and ilike not working for partial or similar text

Similar Threads

Similar Threads

Similar Threads