Laravel Eloquent: Retrieving record via unique (non-id) values

Question

What is the best way to retrieve a record based on a unique value?

I know I can, for example, use: $person = Person::where('fullname', "John Johnson")->first()

Since the fullname only contains unique values, is there a more efficient way similar to when you are using Person::find($id)?

Why is the fullname unique? There might be persons with the same fullname.. — Mihai Matei
– Mihai Matei, Commented Aug 11, 2015 at 12:21

jedrzej.kurylo · Accepted Answer · 2015-08-11 12:22:52Z

2

There shouldn't be any efficiency difference in terms of the query that is being generated - both queries will generate a very similar SQL:

SELECT * FROM persons WHERE id = 5;
SELECT * FROM persons WHERE fullname = 'John Johnson' LIMIT 1;

There can be difference in efficiency that depends on your schema configuration, as primary keys usually have index created automatically and for other columns you need to create the index yourself.

answered Aug 11, 2015 at 12:22

jedrzej.kurylo

41.1k10 gold badges108 silver badges112 bronze badges

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

Collectives™ on Stack Overflow

Laravel Eloquent: Retrieving record via unique (non-id) values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related