my $query = $dbh->prepare
    ( "select id, name from user where name = ?" );
$query->execute( $name_from_params );
[download]

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