need to solve mysql query

hello friend.
need solve order by follwing format
a. street
b. city
c. state
d. zip
I'm using this code but it's not ordering what i want.
SELECT *
FROM test
ORDER BY a, b, c, d ASC ;
it's only ordering street colm.
any help?

See original post by zappak