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

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

I have a bit of code that uses the Mysql module. It is complaining on:
my $query = "SELECT field1,field2 FROM my_table WHERE LEFT(field3) = ' +$var'";
The error returned is:

DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /usr/lib/perl5/site_perl/5.6.1/i386-linux/Mysql.pm line 172.

If I remove the where clause, the error disappears.

edited: Sun Mar 9 14:40:39 2003 by jeffa - code tags