is there a way to delete data in mysql using the 'date' column, i have a table with name message and date. if the date is say yesterday then delete the row....
it is for the shoutbox i am implementing, so i need to delete one messages from yesterday. or is there other ways to delete them(better way)..
ps. sorry about the title i solved that problem