how can i show mysql data alphabeticaly...

Question

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 them as

ibrahm
rafae
testkhan

Answer 1

… ORDER BY some_column 

Answer 2

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

Answer 3

SELECT customer_name 
FROM Customers
ORDER BY customer_name ASC