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]