You can set it as an alias using AS . Respectfully, Ligaya Turmelle
"James E Hicks III" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Isn't there a way to prefix (or postfix) a tables column names in the results > of a select. For example I have a table named from_address. This table has > the column names line1,line2,line3,line4,line5. When I do a select query on > from_address I want all columns to return as from_line1, from_line2, > from_line3, from_line4, from_line5. > > James > > mysql, sql, row, select, delete, from, *, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]