Yes...
Does it work?
- Original Message -
From: "Bob Ramsey" <[EMAIL PROTECTED]>
To: "Lingua2001" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 10:57 AM
Subject: Re: "between A and B" with another condit
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 FR
----- Original Message -
> From: "Oh Chye Yong" <[EMAIL PROTECTED]>
> To: "Lingua2001" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, 18 June, 2003 01:20
> Subject: Re: is CREATE VIEW possible in MySQL?
>
>
> View is not sup
If not, is there a way to get the same effect in MySQL?
Thanks in advance,
Lingua
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
one field?
What if the amount of the database is really huge? How about the performance
speed comparing with the method using
composite key tables as you suggested?
Thanks in advance, again~~~
Lingua
- Original Message -
From: "Ryan Yagatich" <[EMAIL PROTECTED]>
To: &quo
vance, again~~~
Lingua
- Original Message -
From: "Ryan Yagatich" <[EMAIL PROTECTED]>
To: "Lingua2001" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 16, 2003 9:05 AM
Subject: Re: several key values in one field?
> IMHO, I
Hi,
while trying to handle severl key values,
I wonder if it is more efficient to put
those values in a row seperated by a
certain seperator (eg. comma).
The talbe has two fields and looks like;
UID ForeinID
1 2,3,4,6
27,9,4,5
33,4
41,5,7,9
52,3,4,5
and the values of Foreign
