Getting rows containing max date

I have a table named 'news' with following data


news_id news_date news_details
------- ----------- -------------
111111 2009-03-30 News details here
333333 2009-05-14 details eb ert berjtber
222222 2009-04-30 News 222222 title here
444444 2009-05-14 detaaaaisidj sdsd kse


what will be the mySQL query to produce rows containg max date?
The output will be -


333333 2009-05-14 details eb ert berjtber
444444 2009-05-14 detaaaaisidj sdsd kse

 

Well you should have a look at http://www.tizag.com/mysqlTutorial/mysql-date.php

Did you configure the type properly in mysql

 

Data type for 'news_date' filed is 'date'

 

Solved By Me

 

Good to know u solved it..its best to go to phpmyadmin and try to organize it there from the place where u can browse the table they even tell u the query neways good u got it