http://www.perlmonks.org?node_id=344665


in reply to MySQL Regex

You can avoid escaping problems by using placeholders: 

my $sth = $dbh->prepare("... where title regexp ?");
$sth->execute('^\[');

[download]

The '?' is replaced by the value passed to 'execute'. 

perl -e'$b=unpack"b*",pack"H*","59dfce2d6b1664d3b26cd9969503";\
for(;$a<length$b;$a+=9){print+pack"b8",substr$b,$a,8;}'

[download]
My public key

In Section Seekers of Perl Wisdom