OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Alphabetical search to and from

From: Jay Ess (listsnetrogenic.com)
Date: Wed Nov 04 2009 - 09:00:14 CST

Dave M G wrote:
> 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.
>
>
Slow version (no use of index) :
select username from users where left(username,1) between "A" and "B";

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql