[Dbix-class] Newbie from SQL to DBIx

Andreas Dafferner andreas.dafferner at adw.uni-heidelberg.de
Thu Mar 8 12:18:53 GMT 2018


Am 08.03.2018 um 12:56 schrieb Matthew Somerville:

> You could do this:
> 
> FixMyStreet::DB->resultset("Table")->search({}, {
>      columns => { col => \"left(col, length(col)-9)" },
>      distinct => 1,
>      order_by => "left(col, length(col)-9)"  });


Thank you VERY much!!!

Andreas



More information about the DBIx-Class mailing list