many thanks :)
that was exactly what I needed
g
On Nov 26, 2004, at 4:27 PM, Rhino wrote:
- Original Message -
From: "Graham Anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 26, 2004 6:28 PM
Subject: change field names in a query
what is t
- Original Message -
From: "Graham Anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 26, 2004 6:28 PM
Subject: change field names in a query
> what is the proper mysql syntax to change field names after the query
> is done
>
what is the proper mysql syntax to change field names after the query
is done
if I have a table with:
id
englishText
spanishText
picture
And I query the table with:
select id, spanishText
from myTable
limit 30
how do I change the 'spanishText' field name to say 'language' ?
many thanks
g
--
MyS
