In MySQL database, a date field stores dates in YYYY-MM-DD format.
When I do a select * for displaying in a table, I want to display the date in DD-MM-YYYY format...
How? Can anybody tell how to convert?

select date_format(date_field, '%Y-%m-%d') as FORMATTED from table_name