Laravel 5.2 query using query builder

Question

How i do this query using query builder:

SELECT code FROM client WHERE code
//                =(SELECT max(code) FROM client where code LIKE '" . $year . "%')";

i try this:

$row = Client::find(DB::table('client')->max('code'));

but return null

thefallen · Accepted Answer · 2016-06-13 10:20:09Z

4

Try this: Client::where('code', 'LIKE', $year . '%')->max('code');

answered Jun 13, 2016 at 10:20

thefallen

9,8202 gold badges39 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@FabioSantos please, tag answer like a Best, if it works.