[SOLVED] php/mysql ?

[jd2007]

$query = "SELECT Searching.page_title, Searching.info
	FROM Searching WHERE info LIKE '%".$name[$j]."%'";

 

the code above finds matches for $name[$j] in info column in the table Searching...how do i find matches for

$name[$j] in all the columns of the table 'Searching'?

[trq]

$query = "
  SELECT page_title, info
  FROM Searching
  WHERE info LIKE '%{$name[$j]}%'
  OR foo LIKE '%{$name[$j]}%'
  OR bar LIKE '%{$name[$j]}%'
";

[jd2007]

thanks !