getting database results using string matching in my laravel app

Question

I want the rows of a table which have some string 'str' present in a particular column's value.

For ex.- I want all the rows of 'User' table where 'user_name' is 'halku'.

I know about str_contains() and where(), but I want to know how to use them together.

I couldn't find any docs for something like that.

How can I achieve this ?

Sergey Telshevsky · Accepted Answer · 2014-04-01 09:19:16Z

2

In databases this is called a WHERE LIKE statement.

In Laravel you use it like this:

$name = Input::get('name');
$users = User::where('name', 'LIKE', "%$name%")->get();

% is a wildcard. It means get all rows where column name has the word $name and there may be other text before or after that word.

answered Apr 1, 2014 at 9:19

Sergey Telshevsky

12.3k7 gold badges59 silver badges80 bronze badges

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

1 Answer 1