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

luxs has asked for the wisdom of the Perl Monks concerning the following question:

Simple DBI search with slashes do not return anything

my $string = '/a/b/c'; my $req = qq{ SELECT * FROM `texts` WHERE `string`=?}; my $sth = $dbh->prepare($req); my $row = $sth->execute($string); say "row = $row";
produce: row = 0E0

Table `texts`: string varchar(256) utf8_general_ci

How can I perform exact search strings with with slashes?