ilike drizzle postgress

how can i disregard the order of the searchterm? im already replacing whitespaces with % with a regex but the order seems to somewhat matter for ilike? i am wondering if there is any way to have the order of each word disregarded in the queried column, it just looks if its present or not

  const result = await db.query.productsInformation.findMany({
    where: ilike(productsInformation.name, "%" + searchTerm + "%"),
    limit: 50,
  });

  const result = await db.query.productsInformation.findMany({
    where: ilike(productsInformation.name, "%" + searchTerm + "%"),
    limit: 50,
  });

  const result = await db.query.productsInformation.findMany({
    where: ilike(productsInformation.name, "%" + searchTerm + "%"),
    limit: 50,
  });

  const result = await db.query.productsInformation.findMany({
    where: ilike(productsInformation.name, "%" + searchTerm + "%"),
    limit: 50,
  });

ilike drizzle postgress

Similar Threads

Similar Threads

Similar Threads