Hello,
This may be a bad way of querying the database but i wonder if you can perform a query like this
I want to select all fields from a table with .*, on some of the fields, i would like to have it return a different name, i only want to select the table once. I have a large number of fields to return and so want to avoid selecting each individually
so like
SELECT tablename.*, DATE_FORMAT(tablename.date, '%b %d, %Y') AS 'Date_modified'
FROM tablename WHERE tablename.id = 5
I don't want to do this if i can avoid it
SELECT tablename.*, DATE_FORMAT(datetable.date, '%b %d, %Y') AS 'Date_modified'
FROM tablename, tablename AS datetable WHERE tablename.id = 5 AND datetable.id = 5
Any help is appreciated
chuck
