MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Lingua2001 Date:July 22 2003 7:37am
Subject:"between A and B" with another condition?
View as plain text  
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
Thread
Open TablesJohn Farkas17 Jun
  • Re: Open Tablesgerald_clark17 Jun
  • Re: Open TablesBecoming Digital17 Jun
  • Re: Open TablesBecoming Digital17 Jun
  • Re: Open TablesEgor Egorov18 Jun
  • "between A and B" with another condition?Lingua200122 Jul
    • Re: "between A and B" with another condition?Fred van Engen22 Jul
    • Re: "between A and B" with another condition?Bob Ramsey22 Jul
    • Re: "between A and B" with another condition?Bruce Feist22 Jul
  • Re: "between A and B" with another condition?Viorel Dragomir22 Jul
  • Re: "between A and B" with another condition?Lingua200122 Jul