search across several columns

[Anon]

Hello,

I am seeking a way to search across several columns of a table.

This works on one column:
$sql_result = "SELECT * FROM tbl_Index WHERE column1 LIKE '%$search%'";

Is there a way to make it work across more than one column?
Thanks.

[khaine]

$sql_result = "SELECT * FROM tbl_Index WHERE column1 LIKE '%$search%' OR column2 LIKE '%$search%'";