How to do ltrim in laravel leftjoin?

Question

Laravel

Hello.
There is a request like this:

$builder->leftjoin('public.table as test', function ($join) {
            $join->on('test.field1', '=', 'table2.field1')
                    ->on('test.filed2', '=', 'table2.field2');
        });

How can one write for table2.field1 ltrim(table2.field1,'0') or str_replace ?

Answer 1

Do LTRIM at the DB level via DB::Raw()