complex sorting

[Anon]

i have a query that includes dollar values which are in different currencies, i need to pull all these out convert them all to australian dollars then sort the list via the converted dollar value.

is it possible to do this at the database level (mysql) or should i be putting everything into an array and sorting that?

[[deleted]]

If you are just ordering by numbers, then the order of the USD value will be the same as the Australian dollars.

And yes you can (should) do all that in the database.

SELECT USD*Convertion_rate as Ausdollar FROM table ORDER BY Ausdollar;