I think you have to set it for the connection: $dbh->exec("PRAGMA case_sensitive_like = 1;"); Prepare your query afterwards.