How to get table/field infomation

[sidsel]

If a field in a table is set to be varchar(25), how do I find this information using a query?

I wish to use the value as maxlength in a input field in a form

[leatherback]

I think you are after the describe syntax:

http://dev.mysql.com/doc/refman/4.1/en/describe.html