Good point about that first position. Of course, the ending would need an interpretation according to the charset at hand.
select * from country Name between 'F' and 'P\uffff\uffff\uffff\uffff\uffff' - md On Wed, Nov 4, 2009 at 10:26 AM, misiaQ <mis...@poczta.fm> wrote: > 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:mdyk...@gmail.com] > Sent: 04 November 2009 15:19 > To: Dave M G > Cc: mysql@lists.mysql.com > 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 <mis...@poczta.fm> wrote: >> Try this: >> select * from country where LEFT(Name, 1) between 'F' and 'P'; >> >> Regards, >> m. >> >> -----Original Message----- >> From: Dave M G [mailto:d...@articlass.org] >> Sent: 04 November 2009 14:52 >> To: mysql@lists.mysql.com >> 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=mis...@poczta.fm >> >> >> >> ---------------------------------------------------------------------- >> 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=mdyk...@gmail.com >> >> > > > > -- > - michael dykman > - mdyk...@gmail.com > > "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=mis...@poczta.fm > > > > 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/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com "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=arch...@jab.org
