"between A and B" with another condition?

[Lingua2001]

Hi there,

How can I extract values for "members whose level is below '3', and
their names are between the alphabets 'a' and 'b' "?
For example, one of the results should be 'Alex', whose level is '1'.
Or 'Bob', whose level is '2'. But not Charlie, or Tom...etc.

I tried a query like

SELECT uid FROM members WHERE level > '1' AND name between 'a' and 'b',

but it does not work....

Could anyone give me a good solution?

Thanks for your help in advance.

Lingua

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw