getting all columns that match a name

[George Parkinson]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130522/f2a799e6/attachment.html>