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.

[Back to original message]