my $query = $dbh->prepare ( "select id, name from user where name = ?" ); $query->execute( $name_from_params ); #### my $query = $dbh->prepare ( "select id, name from user " . "where name = '$name_from_params'" ); $query->execute();