-
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)
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) |
++--+-+
>(4) My intention is a query like
>mysql> select id,name from tt wh
My 1st question, can be understood after 3 steps below:
(1) Suppose we have a table defined as:
mysql> desc tt;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| id | int(
