How to query a range of data in MySQL?

[Lauj]

Does anyone know a quick way to query a range of data from MySQL database? For example, I want to query any person who have a last name starting with M to P or to query using a range of years such as from 1980 to 2000 . Is there a quick and easy SQL statement to do this?

Your suggestion is much appreciated.

Charlie

[bastien]

use LIKE on IN or between statements depending on the query

ie

select lastname from table where left(lastname,1) between 'M' and 'P'

[Lauj]

Thanks! Looks like BETWEEN will work...I'll test and see what happends.

Charlie