$all = $dbh->selectall_arrayref("SELECT ID,col_1, col_2 FROM table WHERE LOWER(col_1) LIKE '$searching_string%'");