Simon Oliver wrote:
>
> Looking through the docs I notice that CLIKE is mentioned, but there is no
> explanation of the difference between the two operators - perhaps there should
> be.
I'm working on the POD now. Here's what it will say:
The "CLIKE" operator works exactly the same as the "LIKE"
operator, but is case insensitive. For example:
WHERE foo LIKE 'bar%' # succeeds if foo is "barbaz"
# fails if foo is "BARBAZ" or "Barbaz"
WHERE foo CLIKE 'bar%' # succeeds for "barbaz", "Barbaz", and
"BARBAZ"
Sound ok?
--
Jeff
