SELECT foo FROM bar WHERE name LIKE '%ME%';

##</code><code>##

for (@array) {
    print "$_ matches\n" if $_ =~ /ME/;
}