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
- 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
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
Like this?
mysql select * from t2;
+-++
| name| number |
+-++
| bob | 3 |
| bob | 2 |
| bob | 1 |
| al | 1 |
| al | 2 |
| al | 3 |
| al | 4 |
| adam| 4 |
| adam| 3 |
| adam
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