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=arch...@jab.org
