Hi! Can anyone help me how can I achieve the search functionality like Instagram with Supabase Current Code

let { data, error } = await supabase_connect
      .from("Users")
      .select("name, username, verified, image_url")
      .ilike("name", `%${req.body.name}%`)
      .range(req.body.skip, req.body.limit);

Tried

.textSearch()

but it didn't worked out what actually I wanted.

Move the conversation here, from what you are asking you want to remove the last

%

at the end of your

.ilike

.

I did but the surname is not getting search

Yes because its not the end

as there is a gap between the name

What you are after requires more complex search query

yes

like

cannot give you that result

ya so what should be the approach to get the result

Do a google search on how to do that sort of complex search with SQL and you can use what you find and create a Postgres function then call it via the supabase

.rpc

function

Thanks for the help