Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Jay Ess (listsnetrogenic.com)
Date: Wed Nov 04 2009 - 09:00:14 CST
Dave M G wrote:
> 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