<html><body><div style="color:#000; background-color:#fff; font-family:lucida console, sans-serif;font-size:10pt"><div><span>yes indeed, but i'm looking for all table names that have a field 'productid' (in one query)</span></div><div style="color: rgb(0, 0, 0); font-size: 13.600000381469727px; font-family: 'lucida console', sans-serif; background-color: transparent; font-style: normal;"><span><br></span></div><div>thanks</div><div>george</div><div><br></div> <div style="font-family: 'lucida console', sans-serif; font-size: 10pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Bart Pietercil <bart.pietercil@cognosis.be><br> <b><span style="font-weight: bold;">To:</span></b> Valentina Developers <valentina@lists.macserve.net> <br> <b><span style="font-weight: bold;">Sent:</span></b>
Wednesday, May 22, 2013 10:59:12 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: getting all columns that match a name<br> </font> </div> <div class="y_msg_container"><br><div id="yiv514199923"><div>select * from (show fields of tblName) where fld_name = 'productID';<div><br></div><div>mind you check fieldname to use for fld_name by doing a 'show fields of tblName' first</div><div><br></div><div>hth,</div><div><br></div><div>Bart </div><div><br><div><div>On 22 May 2013, at 16:54, George Parkinson <<a rel="nofollow" ymailto="mailto:george@microtherapy.ca" target="_blank" href="mailto:george@microtherapy.ca">george@microtherapy.ca</a>> wrote:</div><br class="yiv514199923Apple-interchange-newline"><blockquote type="cite"><div><div style="background-color: rgb(255, 255, 255); font-family: 'lucida console', sans-serif; font-size: 10pt;"><div id="yiv514199923"><div style="background-color: rgb(255, 255, 255); font-family: 'lucida
console', sans-serif; font-size: 10pt;"><div id="yiv514199923yui_3_7_2_31_1368763198479_39">hello all,</div><div id="yiv514199923yui_3_7_2_31_1368763198479_39"><br></div><div id="yiv514199923yui_3_7_2_31_1368763198479_39">i'm trying to get a list of all table names in a db that have a specific column name.</div><div id="yiv514199923yui_3_7_2_31_1368763198479_39">ie all user tables with a column named 'productID'.</div><div id="yiv514199923yui_3_7_2_31_1368763198479_39"><br></div><div id="yiv514199923yui_3_7_2_31_1368763198479_39">do i have to use a combination of SHOW TABLES, SHOW COLUMNS, and a loop <span style="font-size:10pt;">or is there simpler way?</span></div><div id="yiv514199923yui_3_7_2_31_1368763198479_39"><span style="font-size:10pt;"><br></span></div><div id="yiv514199923yui_3_7_2_31_1368763198479_39"><span style="font-size:10pt;">thanks,</span></div><div id="yiv514199923yui_3_7_2_31_1368763198479_39"><span
style="font-size:10pt;">george</span></div><div id="yiv514199923yui_3_7_2_31_1368763198479_39"><span style="font-size:10pt;"><br></span></div><div id="yiv514199923yui_3_7_2_31_1368763198479_39"><br id="yiv514199923yui_3_7_2_31_1368763198479_69"></div><div id="yiv514199923yui_3_7_2_31_1368763198479_39" style="font-size: 13.600000381469727px; font-family: 'lucida console', sans-serif; background-color: transparent; font-style: normal;"><br></div><div id="yiv514199923yui_3_7_2_31_1368763198479_39"><br></div></div></div></div></div>_______________________________________________<br>Valentina mailing list<br><a rel="nofollow" ymailto="mailto:Valentina@lists.macserve.net" target="_blank" href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina<br></blockquote></div><br></div></div></div><br>_______________________________________________<br>Valentina mailing list<br><a
ymailto="mailto:Valentina@lists.macserve.net" href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br><br><br></div> </div> </div> </div></body></html>