my $t = "Bobby Tables' and HeadName=1; drop table mytable;";
my $SQL = "select * from mytable where id='$t'";
print $SQL, "\n";

##</code><code>##

select * from mytable 
where id='Bobby Tables'
and   HeadName=1;

drop table mytable;