----- Original Message ----- From: "Lingua2001" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 10:37 AM Subject: "between A and B" with another condition?
> 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', if you want the level below 3 then set the where clause with level < 3 i guess this is your query: SELECT uid FROM members WHERE level < 3 AND name between 'a' and 'b', i recommend that your level is defined as a number, otherwise you must make a cast to number (int) because '3'>'13' /v > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
