I am no mysql expert, but I know enough to get by, what I wish to know is this:-
SELECT * FROM `Atable`;
This selects the WHOLE contents of all the columns, all good, but now if I wanted to make use of the timestamped 'date' column I would use this:-
SELECT DATE_FORMAT(`Date`, '%a %D %b %Y %k:%i') AS `getDate` FROM `Atable`
But doing this means that I am only requesting the 'date' column.
I would like to know what the correct approach would be to asking for the date using date_format() as well as ALL the other fields without having to name them individually.