sry twice I guess 1. if this is in the wrong place wasnt sure wot it comes under! and 2. if its been asked already I've tried different searchs and not found anything.
anyway...
I have a table in a MySQL database that has a list of product types
and i want to display say A to M in one place and N to Z in another place
the table has Id and name
example records : 1 | Bags
what is the SELECT statement for this?
Cheers
Andrew