Using Eloquent ORM in Laravel to perform search of database using LIKE

Question

I want to use Eloquent's active record building to build a search query, but it is going to be a LIKE search. I have found the User::find($term) or User::find(1), but this is not generating a like statement. I'm not looking for a direct answer, but if someone could at least give me a direction to look in that'd be great!

Answer 1

You're able to do database finds using LIKE with this syntax:

Model::where('column', 'LIKE', '%value%')->get(); 

Answer 2

If you need to frequently use LIKE, you can simplify the problem a bit. A custom method like () can be created in the model that inherits the Eloquent ORM:

public  function scopeLike($query, $field, $value){         return $query->where($field, 'LIKE', "%$value%"); } 

So then you can use this method in such way:

User::like('name', 'Tomas')->get();