Only return records by their alphabetical range

[refiking]

I am trying to display all the records that begin with A - M only.  Here is the basic query:

 

mysql_query("select stores_title, stores_id from stores");

[PFMaBiSmAd]

select stores_title, stores_id from stores WHERE stores_title REGEXP '^[a-m]' ORDER BY stores_title

[JustLikeIcarus]

Same as the one above just modified so that case isn't an issue.

 

select stores_title, stores_id from stores WHERE lower(stores_title) REGEXP '^[a-m]' ORDER BY stores_title

[PFMaBiSmAd]

REGEXP is not case sensitive, except when used with binary strings.