Mysql select with LIKE and php variable

[mluci12]

How can i create a %Like select where variable is a php variable.

I think, like this sql:

Code: Select all

$varnm ='value';
$sql = "SELECT * FROM table_name WHERE col_name LIKE '%$varnm'"; 

how can i put 2 col_name in this sql ?

Simple, like this:

Code: Select all

$varnm ='value';
$sql = "SELECT * FROM table_name WHERE col_1 LIKE '%$varnm' OR col_2 LIKE '%$varnm'";