[UPHPU] MySQL Question

[Orson Jones]

Walter Scott wrote:
>>> Anyone know how to read a MySQL comment?
>>>
> 
>> Show us the comment and I will tell you if I can read it.
>>
>> Jonathan
> 
> I think I stated my question improperly.  In phpMyAdmin there is a Field
> comment, I want to know how to read that comment in a script kind of the way
> you would query a record I want to query the comment.

SELECT `COLUMN_COMMENT`
FROM information_schema.`COLUMNS`
WHERE `TABLE_SCHEMA` = 'dbname'
AND `TABLE_NAME` = 'tablename'
AND `COLUMN_NAME` = 'columnname'

Orson