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]
