How to Use `LIKE` with `orWhere` in Laravel 5 Eloquent for Database Queries?

Translating 'LIKE' in Laravel-5 Eloquent

In Laravel 5, Eloquent provides a convenient method to perform complex database queries. One common operation involves searching data using the 'LIKE' operator. However, users have reported encountering difficulties with the 'orWhereLike' method.

To achieve the equivalent of the following MySQL statement:

select * from booking_dates where email='[email protected]' or name like '%John%'

in Laravel 5, we can utilize the following Eloquent syntax:

BookingDates::where('email', Input::get('email'))
    ->orWhere('name', 'like', '%' . Input::get('name') . '%')
    ->get();

By combining the 'where' and 'orWhere' methods, we can search for values that either match a specific criterion or contain a particular substring. It is crucial to note that when using 'like' with Eloquent, you should include the % wildcard character at the beginning and end of the search string to find partial matches.

To verify the SQL query generated by Laravel, you can use the dd(DB::getQueryLog()) helper function, which outputs the executed queries to the console. This will allow you to confirm that the desired search parameters are being applied correctly in the database.

The above is the detailed content of How to Use `LIKE` with `orWhere` in Laravel 5 Eloquent for Database Queries?. For more information, please follow other related articles on the PHP Chinese website!