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