At 3:07 PM -0600 8/20/99, Ryan Jameson wrote:
>16.10 of the manual says that "By default, MySQL searches are
>case-insensitive........search with column LIKE 'a%' you will get all column
>values that start with A or a.
>
>So why when I search with column LIKE '%banannas%' I don't get ones with
>'Banannas' ???
Is it a binary column? Then you don't get the default comparison,
you get case sensitive comparison.
To force case insensitive comparison in such a case, use LOWER() or
UPPER() on both operands.
--
Paul DuBois, paul@stripped
