This bit of code (update: shown above) looks very interesting. Can anyone convert the SQL easily into MySQL speak? Am I right in thinking that the syntax shown is Oracle?

my $ST = $DB->prepare(<<EOSQL);
SELECT ?, ?, A.entity_name 
FROM e_annotation_090812.annotation A 
join e_annotation_090812.Temp_table T on T.Line=A.user
where length(A.entity_name)>0
  and (
     length(A.evidence_code)<12 
     or substr(A.evidence_code,length(A.evidence_code)-2,1)!='8')
  )
  and (A.centre=? or A.centre=?)
EOSQL
$ST->execute($Reference, $Comparitor, ".$Reference.", ".$Comparitor.")
[download]