Odd Sql syntax

[jonsof]

i would like to do something like this sql syntax

SELECT * (DATE_FORMAT(date_posted, '%e-%m-%Y')AS date_posted) FROM post WHERE postid='".$_GET['post_id']."'

i want to recieve all the fields and format the date contemporary!

[ultraslacker]

• is shorthand for all columns - alias date_posted distinctly and add a comma after the asterick.

[jonsof]

It worked, thank you!