how can i show mysql data alphabeticaly

i have the following mysql table....

-----------------------
id customer_name date 
-----------------------

now let me know the query with which i will able to show data Order by alphabeticaly...

where values of customer_fields are like testkhan, rafae, ibrahm and i want to show th开发者_开发技巧em as

ibrahm

rafae

testkhan

… ORDER BY some_column 

I think you're looking for something like this, assuming the table name is 'Customers' and you want to order by customer_name descending:

SELECT *
FROM Customers
ORDER BY customer_name

SELECT customer_name 
FROM Customers
ORDER BY customer_name ASC