Subject Re: [firebird-support] Containing vs. Like
Author Helen Borrie
At 02:32 PM 23/09/2004 +0200, you wrote:
>Should bottom queries do the same thing ?
>select * from table where field like '%text%'
>select * from table where field containing 'text'
>Is any approach faster then another ?

Yes and no. They are not exactly the same. CONTAINING is
case-insensitive, in character sets that support uppercase/lowercase
mappings. A case-insensitive search can be more costly than a
case-sensitive one. Neither is fast, since indexes cannot be used to
assist these searches.