Date order question

[cturner01]

I am wanting to make a query so my database will display the table content into date order. Can someone please tell me how to do that? Thanks in advance.

Mediareleases table structure:
id // the autoincremented primary key number
title // type: text
text // type: text
date_entered // for example: Monday, March 17, 2008. Type: text

[r937]

to begin, you must change the format of your date_entered column from text to DATETIME

[cturner01]

Won't that effect the current data that is in the database?

[r937]

well, you could add an additional DATETIME column, then update it from the existing text column using STR_TO_DATE, then drop the text column