...
$value =~ s/drop table//igs;
...