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

Reply via email to