Den 2012-10-31 10:45 skrev Svein Erling Tysvær såhär:
>
> I tried manually LIKE with and without the addition of STARTING WITH
> and tried what I thought was likely to have worse performance with
> STARTING WITH - when the parameter starts with a wildcard. With
> STARTING WITH, my query executed
I second that
Regards Bogdan
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann Harrison
Sent: Tuesday, October 30, 2012 3:36 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Parameterised like query won't use ind
On Tue, Oct 30, 2012 at 4:50 AM, Kjell Rilbe wrote:
>
> ... if it contains no wildcards (% and _), use: where myfield =
> :myparameter ...
> If it contains a single % wildcard at the end...
> If it contains multiple wildcards, but none at the beginning...
> .If the search string starts with a wi
> Now, I wonder if something similar could actually be done internally by
> Firebird for the general like case?
That gets my vote!
Den 2012-10-30 08:45 skrev roydamman såhär:
>
>
> Hello Helen, you are right, not to use LIKE for a normal search. But
> LIKE was used to give the users of my programs, the most flexibel
> search options. It seems not a good practice.
>
You could analyze the search string entered by the user, an