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


in reply to Re^2: DBI search for forward slash
in thread DBI search for forward slash

But = only compares for identity. You want LIKE, and you want the % placeholder:

SELECT * FROM `texts` WHERE `string` LIKE '%/a/b/c%'

... or, with placeholders:

SELECT * FROM `texts` WHERE `string` LIKE ?

(and then in the ->execute() call, add the placeholders to your search string)