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 <[email protected]> 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:[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] > > -- - 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]
