How to use the 'in' of SQL using Class::DBI

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

How to use the 'in' of SQL using Class::DBI

Eg: SELECT * FROM T1 WHERE COL1 IN ('AX','BX').

How can I implement the same in Class::DBI.

Comment on How to use the 'in' of SQL using Class::DBI

Replies are listed 'Best First'.
Re: How to use the 'in' of SQL using Class::DBI by fenLisesi (Priest) on May 21, 2007 at 09:23 UTC
Class::DBI::AbstractSearch and Class::DBI::Sweet should let you use `-in`, as in this untested bit: `MyClass->search_where({ col1 => { -in => \@items }})` [download] Hope this helps.	[reply] [d/l] [select]