Depending on the size of your table, it can be faster using
SELECT lastname FROM employee WHERE lastname BETWEEN 'm' AND 'z' GROUP
BY lastname;
On a table with 2,5 Mill. records the speed diff is over 1000% on my system.
ViSolve DB Team wrote:
Hello Paul,
You can try this:
SELECT DISTINCT
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
Subject: Searching through an alphabetical r
'z';
> +-+
>
> | 'seal' >= 'm' AND 'seal' <= 'z' |
>
> +-+
>
> | 1 |
>
> +-----------------+
> 1 row in
+-+
>
> | '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
