my $sth = $dbh->prepare( "select bar from foo where bar=baz" ); $sth->execute; # selects rows where 2 columns have same values # vs: my $sth = $dbh->prepare( "select bar from foo where bar=?" ); $sth->execute( "baz" ); # selects rows where bar='baz' (3-letter literal)