From: Dan Nelson Date: November 4 2003 11:50pm Subject: Re: query time in ~3M row table List-Archive: http://lists.mysql.com/mysql/153029 Message-Id: <20031104235008.GB28915@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii In the last episode (Nov 04), Brent Baisley said: > I had thought it was inclusive, but in quick tests I discovered it > was not. I haven't tried to look it up in the documentation yet. In > my test I did a query on a contact database like this: select > lastname from contacts where lastname between 'A' and 'B'; > > Only 'A' names are returned. Yes, there are hundreds of 'B' names. But are there any records where lastname = "B"? "Baker" sorts below "B", for example. -- Dan Nelson dnelson@stripped