an try this:
SELECT DISTINCT lastname FROM employee WHERE lastname BETWEEN 'm' AND 'z';
Thanks,
ViSolve DB Team.
- Original Message - From: "Paul Nowosielski"
<[EMAIL PROTECTED]>
To:
Sent: Friday, July 21, 2006 10:33 PM
Subject: Searching through an alpha
Hello Paul,
You can try this:
SELECT DISTINCT lastname FROM employee WHERE lastname BETWEEN 'm' AND 'z';
Thanks,
ViSolve DB Team.
- Original Message -
From: "Paul Nowosielski" <[EMAIL PROTECTED]>
To:
Sent: Friday, July 21, 2006 10:33 PM
Subjec
im Lucia
Subject: Re: Searching through an alphabetical range
Its working fine for me:
mysql> SELECT DISTINCT email_address FROM mailing_list WHERE marketing_list
LIKE 'Y' AND last_name >= 'm' AND last_name <= 'z';
26371 rows in set (1.00 sec)
Thank You,
--
Paul
+-+
>
> | 'seal' >= 'm' AND 'seal' <= 'z' |
>
> +-+
>
> | 1 |
>
> +-+
> 1 row in set (0.00 sec)
>
> mysql>
>
> '
--+
| 1 |
+-+
1 row in set (0.00 sec)
mysql>
'zz' will probably do the trick, though.
Tim
> -Original Message-
> From: Paul Nowosielski [mailto:[
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 range
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
