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


in reply to Mysql module

I'm not a Mysql buff, so I don't know about the syntax of Mysql's LEFT(). Typically LEFT() functions take another argument: how many characters to extract from the left side.

However the " leads me to belive that there is a double quote in $var. Try printing $query to see what's in it.

If that's the case, do something like this before the my $query... thing.

$var = $dbh->quote($var);