At 02:32 PM 23/09/2004 +0200, you wrote:

>Hello!
>
>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.

./helen