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 |
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) |
++--+-+
snip
(4) My intention is a query like
mysql select id,name from tt
| (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
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) |
++--+-+
snip
(4) My intention is a query