Try this:
select * from country where LEFT(Name, 1) between 'F' and 'P';
Regards,
m.
-----Original Message-----
From: Dave M G [mailto:dave@stripped]
Sent: 04 November 2009 14:52
To: mysql@stripped
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=1
----------------------------------------------------------------------
Konkurs: Wygrywaj nagrody z Pudzianem!
Sprawd
