Eloquent: request field length in Laravel

Question

I want to do something like this in Laravel (valid sqlite query):

select * from 'tbUsers' where  length(name)>50;

I tried

User::with('Permissons')->where('LENGTH(name)','>','50')->get();

But it does not seem to work ........

note : other queries work without problems:

User::with('Permissons')->where('active','=','1')->get();

Answer 1

try it whereRaw( string $sql, array $bindings = array(), string $boolean = 'and')

User::with('Permissons')->whereRaw('LENGTH(name) > 50')->get();

Answer 2

Use whereRaw:

User::with('Permissons')->whereRaw('LENGTH(name) > ?', [50])->get();