| Subject | Re: [ib-support] containing, like, = |
|---|---|
| Author | raptor |
| Post date | 2001-09-07T11:28:42Z |
so if I have to sum up the things :
STARTING WITH - sensitiveORno?, uses index, no wildcards
LIKE - case sensitive, uses index if "NAME%", no index if "%NAME%", wilcards
allowed
CONTAINING - case insensitive, doesn't use index, no wildcards
=====
iVAN
raptor@...
=====
STARTING WITH - sensitiveORno?, uses index, no wildcards
LIKE - case sensitive, uses index if "NAME%", no index if "%NAME%", wilcards
allowed
CONTAINING - case insensitive, doesn't use index, no wildcards
=====
iVAN
raptor@...
=====