Wade Preston Shearer wrote:
Are you using a version of MySQL that supports Views? If so, just
make a View that has the column names the way you want, and then
SELECT from the View instead of directly from the table.
That doesn't actually eliminate having to list each field though, right?
Right. There's no SQL magic that I know off where you can rename each
field uniformly in a SELECT statement (using some magic AS clause) like
s/prefix/my_prefix/
--Dave
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
