Search for non-exact match of string[]

[quan612]

Hi,

Just wondering if we can do a non-exact match search on string[]

I try to take the example from /src/tests folder

Given we have the schema:

const db = await create({
    schema: {
      name: 'string[]'
    } as const
  })

Then we populate the data as:

   const albusId = await insert(db, {
    name: ['Albus', 'Percival', 'Wulfric', 'Brian']
  })

  const [harryId, jamesId, lilyId] = await insertMultiple(db, [
    { name: ['Harry', 'James', 'Potter'] },
    { name: ['James', 'Potter'] },
    { name: ['Lily', 'Lily', 'Lily', 'Lily', 'Evans', 'Potter'] }
  ])

If we do this search:

 const result = await search(db, {
    term: "P"
  })

then it returns some values as it matches Potter

but if we do

  const result = await search(db, {
    term: "ot"
  })

or

  const result = await search(db, {
    term: "o"
  })

then it returns blank array

[quan612]

It works partially by following an example in this ticket. Did not test all cases but works for my basic case.

#155