in reply to
Re^2: DBD::CSV - SQL Syntax - "AND" clause is not working properly
in thread DBD::CSV - SQL Syntax - "AND" clause is not working properly
When posting please provide an example which you are actually running, not doing this potentially wastes peoples time, posting unrelated code and a made up problem. I've provided a working example based on your csv file and the query you ran. Stop using variables like this, read and understand 'Placeholders and bind values' from the DBI documentation and never ever forget the ballad of Little Bobby Tables. SQL_injection.