Subject Re: [IBO] Searching for a string into a string
Author Svein Erling
Sorry Helen,

> WHERE MyStringField CONTAINING 'stre'
> If MyStringField is indexed, then the case-sensitive search will
> use the index (=fast).

there is no way CONTAINING can use an index. STARTING [WITH] use
indexes, but CONTAINING implies that the engine doesn't know if what
it searches for is at the beginning of the field, and hence not where
to lookup in an index.

The only way to get something like this indexed must be to use Jasons
components for free text search (or whatever FTS means).