Thanx for the answer, you can also use -
SELECT column_name from information_schema.columns WHERE column_name LIKE ’%searchTerm%’ AND table_schema = ‘yourDB’
and to target a specific table -
SELECT column_name from information_schema.columns WHERE column_name LIKE ’%searchTerm%’ AND table_schema = ‘yourDB’ AND table_name = ‘yourDBTable’
<?
// PHP CODE //
mysql_connect(“dbHost”, “dbUserName”, “dbPassword”) or die(mysql_error());
mysql_select_db(“yourDB”) or die(mysql_error());
$cquery = mysql_query(“SELECT column_name from information_schema.columns WHERE column_name LIKE ’%searchTerm%’ AND table_schema = ‘yourDB’ AND table_name = ‘yourDBTable’”)or die(mysql_error());
while($cqueryres = mysql_fetch_assoc($cquery))
{
echo $cqueryres[‘column_name’];
}
?>