my $select_1="lan1"; my $select_2="lan2"; my $all_select = $dbh->selectall_arrayref("SELECT ID,lan1,lan2,lan3,lan FROM table WHERE LOWER($select_1) LIKE '%$Word%' OR LOWER($select_1) LIKE '%$Word'");