Hi,
You're right on one hand. But on the another in some languages you have a
more characters after the Z letter.
Apart from that try this:
select 'F' as test
union
select 'FAA'
order by test;
and you'll see:
test
---------
F
FAA
Regards,
m.
-----Original Message-----
From: Michael Dykman [mailto:mdykman@stripped]
Sent: 04 November 2009 15:19
To: Dave M G
Cc: mysql@stripped
Subject: Re: Alphabetical search to and from
Haven't tried this myself, but would this not work while permitting
the index to engage?
select * from country Name between 'FAAAAAAAAAA' and 'PZZZZZZZZZZ'
On Wed, Nov 4, 2009 at 10:15 AM, misiaQ <misiaq@stripped> wrote:
> Try this:
> select * from country where LEFT(Name, 1) between 'F' and 'P';
>
> Regards,
> m.
>
> -----Original Message-----
> From: Dave M G [mailto:dave@stripped]
> Sent: 04 November 2009 14:52
> To: mysql@stripped
> Subject: Alphabetical search to and from
>
> MySQL,
>
> This should be a fairly simple question.
>
> I have a table with a bunch of people's names. I want to find people
> who's name begins within a certain range of characters.
>
> All names between F and P, for example.
>
> What SELECT statement would I use to do that?
>
> Thank you for any advice.
>
> --
> Dave M G
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
>
> ----------------------------------------------------------------------
> Konkurs: Wygrywaj nagrody z Pudzianem!
> Sprawd¼ >> http://link.interia.pl/f240e
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
- michael dykman
- mdykman@stripped
"May you live every day of your life."
Jonathan Swift
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Tanie rozmowy telefoniczne!
Sprawdz >> http://link.interia.pl/f2410
