Not quite... mysql> select 'zebra' >= 'm' AND 'zebra' <= 'z'; +-----------------------------------+ | 'zebra' >= 'm' AND 'zebra' <= 'z' | +-----------------------------------+ | 0 | +-----------------------------------+ 1 row in set (0.00 sec)
mysql> select 'seal' >= 'm' AND 'seal' <= 'z'; +---------------------------------+ | 'seal' >= 'm' AND 'seal' <= 'z' | +---------------------------------+ | 1 | +---------------------------------+ 1 row in set (0.00 sec) mysql> 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz' will probably do the trick, though. Tim > -----Original Message----- > From: Paul Nowosielski [mailto:[EMAIL PROTECTED] > Sent: Friday, July 21, 2006 2:10 PM > To: mysql@lists.mysql.com > Subject: Re: Searching through an alphabetical range > > > I have the solution: > > > SELECT DISTINCT email_address FROM mailing_list WHERE last_name >= 'm' AND > last_name <= 'z' > > Thank you, > > -- > Paul Nowosielski > Webmaster > > > On Friday 21 July 2006 11:03, Paul Nowosielski wrote: > > Dear All, > > > > I need to write a query that searches last names between the ranges of m > > through z. > > > > Is there a way to do this in the query? > > > > > > Thank You, > > > > -- > > Paul Nowosielski > > Webmaster > > office: 303.440.0666 ext 219 > > cel: 303.827.4257 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
