How on earth will that help? What does the ASCII (byte) code of GRP_COL
have to do with what Dan wants?
[EMAIL PROTECTED] wrote:
Hi,
try for axample,
select PK, ord(GRP_COL),COL from your_table;
Mathias
Selon Dan Bolser <[EMAIL PROTECTED]>:
Hello,
I have data like this
PK GRP_COL
1 A
2 A
3 A
4 B
5 B
6 B
7 C
8 C
9 C
And I want to write a query to select data like this...
PK FK GRP_COL
1 1 A
2 1 A
3 1 A
4 4 B
5 4 B
6 4 B
7 7 C
8 7 C
9 7 C
Where FK is a random (or otherwise) member of PK from within the
appropriate group given by GRP_COL. FK recreates the grouping from
GRP_COL, but in terms of PK. I want to do this because GRP_COL is
difficult to handle and I want to re-represent the grouping in terms of PK
(this allows me to link data into the grouping more easily).
Is there a simple way to do this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]