Hi
I have a table with an id and some numeric fields (ej. between 0 and 30). Suppose this is the structure: id, f1, f2, f3, f4, f5
If the table have values
id1, 3, 5, 20, 17, 10
id2, 18, 4, 9, 30, 1
id3, 23, 15, 12, 27, 14
I want a Select that shows the fields in numeric order
id1, 3, 5, 10, 17, 20
id2, 1, 4, 9, 18, 30
id3, 12, 14, 15, 23, 27
or print to a file
id1,3,5,10,17,20
id2,1,4,9,18,30
id3,12,14,15,23,27
Is there a function in mysql that can be usefull to accomplish this?
Thanks
I have a table with an id and some numeric fields (ej. between 0 and 30). Suppose this is the structure: id, f1, f2, f3, f4, f5
If the table have values
id1, 3, 5, 20, 17, 10
id2, 18, 4, 9, 30, 1
id3, 23, 15, 12, 27, 14
I want a Select that shows the fields in numeric order
id1, 3, 5, 10, 17, 20
id2, 1, 4, 9, 18, 30
id3, 12, 14, 15, 23, 27
or print to a file
id1,3,5,10,17,20
id2,1,4,9,18,30
id3,12,14,15,23,27
Is there a function in mysql that can be usefull to accomplish this?
Thanks