-
From: Peter Brawley
To: YL
Cc: mysql@lists.mysql.com
Sent: Saturday, September 03, 2005 12:34 AM
Subject: Re: string->array question. ( 2 query questions)
YL,
(2) the rows in the table are
mysql> select * from tt;
++--+-+
| id | name | options |
++---
1 | abc | (1,2,3) |
| 2 | bbc | (2,3,7) |
| 3 | cbc | (3,1,7) |
++--+-+
- Original Message -
From: Peter Brawley
To: YL
Cc: mysql@lists.mysql.com
Sent: Saturday, September 03, 2005 12:34 AM
Subject: Re: string->array question. ( 2 query questions)
[EMAIL PROTECTED]>
To: "YL" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, September 02, 2005 2:29 PM
Subject: Re: 2 query questions
Answers blended in
"YL" <[EMAIL PROTECTED]> wrote on 09/02/2005 04:18:27 PM:
I've
Friday, September 02, 2005 2:29 PM
Subject: Re: 2 query questions
> Answers blended in
>
> "YL" <[EMAIL PROTECTED]> wrote on 09/02/2005 04:18:27 PM:
>
> > I've 2 basic questions. thanks for responses:
> >
> > (1) Suppose i have a tab
Answers blended in
"YL" <[EMAIL PROTECTED]> wrote on 09/02/2005 04:18:27 PM:
> I've 2 basic questions. thanks for responses:
>
> (1) Suppose i have a table with a varchar colum named options which
stores
> option id's in the form
> "(id1, id2, , idk)", where id1,... are string repr
please write 2 emails for 2 unrelated questions, that said I will tackle
#2
you have all those line drawing chars since the field is very wide.
The MySQL client does not 'know' about new lines, it just prints them out,
so each one is counted as one char.
in your client you can ask for help,
I've 2 basic questions. thanks for responses:
(1) Suppose i have a table with a varchar colum named options which stores
option id's in the form
"(id1, id2, , idk)", where id1,... are string representations of
positive integers. Given an integer i,
I want to fetch all ID's for the re