Mysql ORDER BY Question.

[wxdqz]

Is There a way to order a table from lets say c to b(cdefghijklmnopqrstuvwxyzab)?
This is the code i'm using now:
SELECT * FROM addressbook ORDER BY name;