10 messages in com.mysql.lists.mysqlRe: query time in ~3M row table
FromSent OnAttachments
jabb...@abbotts.org04 Nov 2003 14:09 
Brent Baisley04 Nov 2003 14:32 
jabb...@abbotts.org04 Nov 2003 15:10 
Matt W04 Nov 2003 15:28 
Dan Nelson04 Nov 2003 15:35 
Brent Baisley04 Nov 2003 15:45 
Dan Nelson04 Nov 2003 15:49 
Brent Baisley04 Nov 2003 15:54 
Brent Baisley04 Nov 2003 15:56 
Matt W04 Nov 2003 16:30 
Subject:Re: query time in ~3M row table
From:Brent Baisley (bre@landover.com)
Date:11/04/2003 03:54:31 PM
List:com.mysql.lists.mysql

Wow, ouch. That is an awfully bright light bulb that just lit up in my head. Duh, too obvious for me to see.

1 comes before 2 except after c.

On Tuesday, November 4, 2003, at 06:50 PM, Dan Nelson wrote:

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.