I Have a simple search query which works just fine
$result = mysql_query("SELECT id, $column, $column2 FROM $table WHERE BINARY account_no='{$_SESSION['account']}' AND $column LIKE '$query' OR $column2 LIKE '$query'") or die(mysql_error());
$output_column=column1 or column2 //which column has been matched?
However when there is a match on a particulat column i would like to be able to find out which column has been matched.
Is this possible?