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/[EMAIL PROTECTED]