Supabase *ilike* queries empty response - discussion

Hey,

For Supabase data filtering we can use a query like "table?name=ilike.*[searchString]*", however, if there is no match, you always get a null error. Has anyone found a way around it?

This young gentleman here (https://www.youtube.com/watch?v=jMLjyYwqJN0&lc=UgzP8pAxwQl5C6AmtZB4AaABAg) found a way around it but it doesn't work when there is exactly one match so it is pretty inconvenient.

1
5 replies