my $sth = $dbh->prepare( "SELECT * FROM $table WHERE REGEXP_LIKE( name, ?, 'i' )" );
$sth->execute( $pattern );