On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote: > You can set it as an alias using AS . > > Respectfully, > Ligaya Turmelle
Yes, I was aware of this option, but I was looking for a way to automatically alias all fields with a set prefix or postfix. On a big table it's a lot of typing to alias all fields. I'm lazy! Thanks. James Hicks sql mysql row query table column -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]