In Laravel, you can take a record based on column value or values

//Many Records
$players = Account::where('playerNo', 99)->get();
//Single Record, basically the first occurance
$player = Account::firstWhere('playerNo', 99);
//Similarly for uniqueness choose the primary key column. Like id.