Hi, On Tue, Jul 22, 2003 at 02:37:14AM -0500, Lingua2001 wrote: > 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', >
I guess your query should work, with 'level < 3' of course. SELECT uid FROM members WHERE level < 3 AND name between 'a' and 'b', > but it does not work.... > Show us your sample data (SELECT uid, level, name FROM members) and the results you get for the query that doesn't work. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]