[Dbix-class] help needed in forming a 'and' and 'or' select query using DBIx::Class

[Michele Beltrame]

Hello!

> columnA = x AND ( columnB = zz OR columnB LIKE '%mm%' )

It should be like this:

$val = 'mm';
$my_rs = $schema->resultset('Mytable')->search({
             columnA => 'x',
             -or => [
                     columnB => 'zz',
                     columnB => { like => '%'.$val.'%' }
             ],
});

Cheers,
Michele.