in reply to Getting error multiple values in where conditon.

Not a Perl question, your SQL is broken.

You need to provide the tested field after WHERE, indicated with <*> in where <*> in

And please better use placeholders!

Cheers Rolf
(addicted to the Perl Programming Language and ☆☆☆☆ :)
Je suis Charlie!

In Section Seekers of Perl Wisdom