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:[email protected]] Sent: 04 November 2009 15:19 To: Dave M G Cc: [email protected] 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 <[email protected]> wrote: > Try this: > select * from country where LEFT(Name, 1) between 'F' and 'P'; > > Regards, > m. > > -----Original Message----- > From: Dave M G [mailto:[email protected]] > Sent: 04 November 2009 14:52 > To: [email protected] > 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/[email protected] > > > > ---------------------------------------------------------------------- > 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/[email protected] > > -- - michael dykman - [email protected] "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/[email protected] Tanie rozmowy telefoniczne! Sprawdz >> http://link.interia.pl/f2410 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
