some text here #### my $myQuery = $dbh->prepare( "SELECT source FROM myTable" ); $source =~ s///g; $source =~ s/<\/data><\/item><\/items><\/element>//g; #### ( "SELECT ('/element/items/item/data') as source FROM myTable WHERE source LIKE '%some string%'" );