Is there a way to search all tables in a MySQL database ?

[jd2007]

Is there a way to search all tables in a MySQL database ?

[jd2007]

i'm sorry...Is there a way to search all tables in a MySQL database for a particular column name ?

[Barand]

try

<?php

$column_name = 'name';      // col to search for

$sql = "SHOW TABLES";
$res = mysql_query($sql) or die (mysql_error()."<p>$sql</p>");
while (list($table) = mysql_fetch_row($res))
{
    $sql2 = "DESCRIBE $table";
    $res2 = mysql_query($sql2) or die (mysql_error()."<p>$sql2</p>");
    while (list($field) = mysql_fetch_row($res2))
    {
        if ($field==$column_name)
        {
            echo "\"$column_name\" found in table \"$table\"<br/>";
        }
    }
    
}
?>

[jd2007]

thanks