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'";
[download]

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