I do believe I’m looking for the same answer.
I have a meta_key and it’s meta_value is an array with two items where one item is an int and the other item is a string.
What is want is the query to be ordered with an meta_compare using the int in the array.
How can I accomplish this? Do I have to make a own meta_key for the int so that the value will become the int I’m looking for, or can I somehow use orderby on a part of the array contained in the meta_value?