|
|
Posted by Mihamina (R12y) Rakotomandimby on 06/22/07 19:19
Derrick Shields - <1182537069.716376.120720@k79g2000hse.googlegroups.com> :
> So here is my question. What is the difference between LIKE 'value'
> and LIKE '%VALUE%'? When you add the percentage signs, I understand
> the percentage signs are wild cards, but if you're using LIKE without
> wildcard percentage signs, is that technically the same as saying
> "="?
Yes, but when searching with a wildcard at the beginning wont use the
created indexes.
That's all.
Navigation:
[Reply to this message]
|