3 messages in com.mysql.lists.win32Re: case sensitivity in searches
FromSent OnAttachments
Ryan Jameson20 Aug 1999 14:06 
Paul DuBois20 Aug 1999 16:16 
Paul DuBois20 Aug 1999 16:17 
Subject:Re: case sensitivity in searches
From:Paul DuBois (pa@snake.net)
Date:08/20/1999 04:17:31 PM
List:com.mysql.lists.win32

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' ???

By the way, it's "bananas". :-)