I'm trying to make a fuzzy search with the following code on a table

products

that has a

many-to-many

relationship to

categories

so that

searchQuery

can be either an

ilike of product.name OR ilike of category.name

but I cannot figure out why it doesn't work

ts
supabase()
  .from<ProductWithIngredients>('products')
  .select('*, ingredients(*), products_ingredients(*), categories(*)')
  .or(`name.ilike.%${searchQuery}%`)
  .or(`name.ilike.%${searchQuery}%`, { foreignTable: 'categories' })
  .throwOnError()
  .then((response) => (isNull(response.data) ? [] : response.data));

Any idea?

Maybe try using

categories!inner

as:

js
supabase()
  .from<ProductWithIngredients>('products')
  .select('*, ingredients(*), products_ingredients(*), categories!inner(*)')  .or(`name.ilike.%${searchQuery}%`)
  .or(`name.ilike.%${searchQuery}%`, { foreignTable: 'categories' })

I've tried that already but it still won't work