List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:August 20 1999 11:17pm
Subject:Re: case sensitivity in searches
View as plain text  
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
Thread
case sensitivity in searchesRyan Jameson20 Aug
  • Re: case sensitivity in searchesPaul DuBois21 Aug
  • Re: case sensitivity in searchesPaul DuBois21 Aug