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.

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Reply via email to