create table measurements ( name varchar ,measurement int ,quality1 int ,quality2 int ,quality3 int );
Obviously, you'd substitute quality1/quality2/etc. with the names of the qualities.
Then, if you want the five measurements for Name1 ordered by size, you use the following SQL statement:
SELECT measurement, size FROM measurements WHERE name = 'Name1' ORDER BY size
Easy as pie.
Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.
In reply to Re: Choosing "best" - sorting hashes issue
by dragonchild
in thread Choosing "best" - sorting hashes issue
by Ineffectual
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |