| Subject | Re: [firebird-support] Using % works for LIKE and not for IN () |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2013-02-16T15:28:38Z |
On 16-2-2013 15:52, venussoftop wrote:
"does itemlist contain a value equal to item": it does not support
partial matches! You either need to use multiple LIKE or STARTING WITH
statements, or use the regular expressions introduced in 2.5 with
SIMILAR TO, although multiple LIKEs are probably more efficient.
Mark
--
Mark Rotteveel
> Hi allYou didn't miss anything. You need to see item IN (itemlist) to mean
>
> When using LIKE I can use the 'String%' to look for partial matches. Not so when I want to use IN ('String%', 'VariousString%') instead I have to use 2 LIKEs
>
> Is there something I missed for using IN ()? That would allow me to use partial matches? The IN keeps the query simpler and shorter than multiple LIKEs IMO.
"does itemlist contain a value equal to item": it does not support
partial matches! You either need to use multiple LIKE or STARTING WITH
statements, or use the regular expressions introduced in 2.5 with
SIMILAR TO, although multiple LIKEs are probably more efficient.
Mark
--
Mark Rotteveel