From: efrazier
Date: April 28 1999 9:43pm
Subject: Finding which tables have a field name _
List-Archive: http://lists.mysql.com/mysql/2563
Message-Id: <2.2.32.19990428214328.00f1e968@192.168.0.1>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

Hi,

How would I go about finding out which tables in a database have a certain
field named "acct"? I was wondering if there might be some extention to the
'show tables' command that would make it easy to find out, without having to
do something with code.  

.....

Ok I did read the manual and ansered my own question :) 

SHOW [COLUMNS|FIELDS] FROM table [FROM database] [LIKE wild] 



Thanks,

Eric