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