Date + text from MySQL

[markjia]

I want to be able to retrieve data from a MySQL table that stores news. in the table, there are two fields that i need:
1) the 'datefield'-stored as type 'Date'
2) the 'news'-stored as text

The problem is how to retrieve both fields in a single query while still formatting the date as MM/DD/YY

The only way I know of retrieving the date in the desided format is:

SELECT DATE_FORMAT(datefield, '%m-%d-%y') as date from tablename

How do I also obtain the 'news' as well as format the date in one query?

The reason I want them in one query is for a faster script, but if there is a faster way of doing this, I'd welcome the idea.

[sp0rk]

It shouldn't be any more difficult than this:
SELECT DATE_FORMAT(datefield, '%m-%d-%y') as date, newsfield from tablename;

[markjia]

i works, thanks for the tip (i'm still fairly new to MySQL)