getting all columns that match a name

[Bart Pietercil]

select * from (show fields of tblName) where fld_name = 'productID';

mind you check fieldname to use for fld_name by doing a 'show fields of tblName' first

hth,

Bart 

On 22 May 2013, at 16:54, George Parkinson <george at microtherapy.ca> wrote:

> hello all,
> 
> i'm trying to get a list of all table names in a db that have a specific column name.
> ie all user tables with a column named 'productID'.
> 
> do i have to use a combination of SHOW TABLES, SHOW COLUMNS, and a loop or is there simpler way?
> 
> thanks,
> george
> 
> 
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130522/d105f45a/attachment.html>