| Subject | Re: [firebird-support] What key word specifies a search for an entire word? |
|---|---|
| Author | Richard Damon |
| Post date | 2019-12-02T11:15:10Z |
On 12/2/19 5:06 AM, Tjioe Hian Pin thp_pkmi@... [firebird-support]
wrote:
force a table scan. Why not just use WHERE fstName = @po
--
Richard Damon
wrote:
>Again, that is likely prevent use of an index to find the record, and
> what about:
>
> SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' '
> containing ' '||@po||' '
>
> Cheers,
> Tjioe
>
force a table scan. Why not just use WHERE fstName = @po
--
Richard Damon