From: Fred Read
Date: April 27 1999 4:12pm
Subject: Re: Detect if field exist
List-Archive: http://lists.mysql.com/mysql/2485
Message-Id: <3725E1DA.21B32B4A@corp.netcom.net.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Poul Christiansen wrote:
> 
> Is is possible to use a select statement or something to 
> find out if a specifik field exists in a table?

It's in the manual;

    Show columns from table like 'string';

You may also want to look at;

    Alter table 
and
    Create table

Read the manual, the manual is your friend...
-- 

If it ain't opinionated, it ain't Rich Teer.