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

##</code><code>##

use Devel::Peek;
Dump($searching_string);