Full Text Search

data = await client
            .from("sneakers")
            .select()
            .textSearch("name", query, {
                type: "websearch",
                config: "english",
            })
            .range(
                page * items_per_page - items_per_page,
                page * items_per_page - 1
            );

data = await client
            .from("sneakers")
            .select()
            .textSearch("name", query, {
                type: "websearch",
                config: "english",
            })
            .range(
                page * items_per_page - items_per_page,
                page * items_per_page - 1
            );

select
  *
from
  sneakers
where
  to_tsvector(name) @@ to_tsquery('jor');

select
  *
from
  sneakers
where
  to_tsvector(name) @@ to_tsquery('jor');