Welcome to WebmasterWorld Guest from 22.214.171.124
this is what i want to happen, i have a table of all currencies in the world. we all know that the ISO code of America, British, Caicos and other country are the same... USD.
how do i query to get only 1 USD in the table...
for normal query:
table description (currencies):
mysql> select isoCode from currencies;
and the result is not good cause a lot of USD is there in the results... how can i have a single USD?